Protecting Menu's & toolbars
 

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.

--
Mark Rosenkrantz
---
Spreadsheet Solutions
Witkopeend 24
1423 SN
Uithoorn, Netherlands
---
E:
W: www.rosenkrantz.nl

Protecting Menu's & toolbars
 

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




--
Regards Ron de Bruin
http://www.rondebruin.nl


"Spreadsheet Solutions" wrote in message . ..
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.

--
Mark Rosenkrantz
---
Spreadsheet Solutions
Witkopeend 24
1423 SN
Uithoorn, Netherlands
---
E:
W: www.rosenkrantz.nl