Protecting Menu's & toolbars

[Spreadsheet Solutions]

Dear NG-ers;

I created a fully functional menu and toolbar for a new application which
works perfectly.
There is only one thing missing and I can't figure out how to do this.
How can I protect Toolbars & Menu's programmatically so that users can't
right click on the commandbar to
"customize" or "add" other toolbars and menu's.

 

[Ron de Bruin]

Hi Spreadsheet Solutions

Try

'Disable right clicking on the worksheet menu bar and other bars
Application.CommandBars("Toolbar List").Enabled = False 'This prevents users double-clicking on the Toolbar area to open the
'(Customize Toolbars) dialog. Only Excel 2002 and up
Application.CommandBars.DisableCustomize = True