MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Hide Menu On Opening - Unhide on Close


Posted by CJMcC on February 21, 2001 8:49 AM

I want to open a *.xls file which, when opened, hides the 'Protection' option from the 'Tools' menu so that the users cannot unprotect(?) the workbook. (Dont want to use passwords due to other macros running in the spreadsheet.)

All my attemps have resulted in my MS Excel application being changed and not the individual file.

Any thoughts?

Thanks in advance ;o)


Posted by Faster on February 21, 2001 9:16 AM

'this may help you
'add this to the ThisWorkbook open module
Application.CommandBars("Tools").Controls(6).Delete

'add this to the ThisWorkbook close module
Application.CommandBars("Tools").Reset