Disabling Button Commands in 2007

[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 de Bruin]

hi da_gl

See this page
http://www.rondebruin.nl/ribbon.htm

 

[Guest]

Ron - thank you very much. This write-up is very helpful. Look like exactly
what i needed.

da_gl