Protecting a RangeName so it cant be changed

[VBAva]

Hello

i have a sheet that contains information about some buttons that i have created, the information is about which buttons should be enabled or not.

for each button i have a named cell associated with it
eg.
Application.CommandBars("Worksheet Menu Bar&quot.Controls("Custom Edit&quot.Controls("RSS&quot.enabled = Sheets("WorkbookInfo&quot.Range("enableRSS&quot

The sheet 'WorkbookInfo' is very hidden and protected from the user, but the range names can still be changed using the Insert>Name> define command.

is there anyway that i can prevent the user from changing these names, or even better, not even know they exist?
so when i hide the sheet, the names associated with it are hidden too??

i hope someone can help

 

[sullivandavid]

While not a perfect one
Set worksheet Menu bar invisible
see previous post

Hard code your named ranges
for example
Sub Set_TradeSize()
Application.ScreenUpdating = False
[tradesize].Activate
FirstCell = ActiveCell.Address
curcolm = ActiveCell.Column
LastCell = Cells(65536, curcolm).End(xlUp).Address
rng = FirstCell & ":" & LastCell
Range(rng).Name = "TradeSize"
[d4].Select
Application.ScreenUpdating = True
End Sub


Have values placed in Autoshapes to conceal formulas

set range names macro to active on change or open close etc
this would frustrate the best on them as it would constantly
reset to the cell references

set your code to private instead of public
make it password protected

Not to say it cannot be changed but it would make very
difficult for us mortal

make the toolbar visible by password only or not at all

have a cell reference activate your password
ie cell zz65000 = "show" password ="show"

you can create a hidden invisible macrobutton
by using autoshapes matching background color and
having no borders no caption or setting the color to transparent linking it to a cell and placing that on a hidden sheet

place your logo or contact info on the hidden sheet to conceal the purpose of holding your macrobutton
or create a splash screen and hide on that sheet
matching background colors etc

have a hidden sheet hold your password
By creating an invisible button you have more than
16 million cells to hide
since using the scroll up or down won't activate the
autoshape button you need to press every cell by hand
to activate

just some suggestions