Disabling Button Commands in 2007

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Historically you could disable Save, Save As, Exit, etc by using the
following:

Application.CommandBars("Worksheet menu
bar").Controls("File").Controls("Exit").Enabled = False

How to do this in Excel 2007?
 
Ron - thank you very much. This write-up is very helpful. Look like exactly
what i needed.

da_gl
 

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

Excel 2007 VBA - Disable "Exit" Command 1
disable a menu control short key 1
Excel 2013 menubar incompatibility? 1
disable shortcut key from menu control 1
Sub Workbook_Open and BeforeClose not working 2
disable Tools/Customize menu option 3
Disable Menu Items 2
Menus in Excel 2007 20

Back
Top