Hi,
Excel 2003.
Within my code I have restricted the toolbar options that a user can access (i.e. for Menu Option 'Edit'\'Delete Sheet'):
VBA:
Code:
Set myCmd = CommandBars("Worksheet menu bar").Controls("Edit")
myCmd.Controls("Delete Sheet").Enabled = False
I have found that users can still delete the sheet if they 'right-click' on a specfic sheet tab.
I don't wish to hide the Worksheet Tabs, I just want to prevent the Users from deleting a specific sheet.
After immobilising the 'Edit'/'Delete Sheet' Menu Option, they can still 'right-click' on the tab - i.e. Insert, Delete or Rename the sheet.
How do disable these options within VBA? Or is there a Menu setting that I can be set to Enabled = False?
Thanks in advance,
Neal
A Northern Soul
Sheet Tab
