Protecting Menu's & toolbars

  • Thread starter Thread starter Spreadsheet Solutions
  • Start date Start date
S

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.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating custom toolbar 3
CommandBar and Controls (how to create separate "Sets" of Controls) 4
Cell Toolbar Dilemma xl2013 13
Add File menu to custom toolbar 4
Macros assigned to Menu Items 2
Cell context menu in XL2007 5
Disable print icon in toolbar?? 8
2007 Quick Access Toolbar 2

Back
Top