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?

hi da_gl

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


--

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


"da_gl" <(E-Mail Removed)> wrote in message news:BC2B2AD8-A555-45AC-A8C5-(E-Mail Removed)...
> 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

"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" <(E-Mail Removed)> wrote in message news:BC2B2AD8-A555-45AC-A8C5-(E-Mail Removed)...
> > 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?
>