ExcelBanter - Disabling Button Commands in 2007

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Disabling Button Commands in 2007 (https://www.excelbanter.com/excel-programming/387435-disabling-button-commands-2007-a.html)

da_gl

Disabling Button Commands in 2007

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

Disabling Button Commands in 2007

hi da_gl

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

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm

"da_gl" wrote in message ...
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?

da_gl[_2_]

Disabling Button Commands in 2007

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

da_gl

"Ron de Bruin" wrote:

hi da_gl

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

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm

"da_gl" wrote in message ...
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?

All times are GMT +1. The time now is 02:34 PM.