View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
da_gl[_2_] da_gl[_2_] is offline
external usenet poster
 
Posts: 1
Default 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?