When you click on the Excel icon which appears on the top left hand corner of
a workbook, several commands become available. Can I disable the command
say 'New Window' using vba? Any help is very much appreciated.

Hi Francis

Start here
http://www.rondebruin.nl/menuid.htm

To disable the whole bar use
Application.CommandBars("Document").Enabled = False


--
Regards Ron de Bruin
http://www.rondebruin.nl



"Francis Ang" <(E-Mail Removed)> wrote in message news:3B2C7CC6-63F0-46DF-BD80-(E-Mail Removed)...
> When you click on the Excel icon which appears on the top left hand corner of
> a workbook, several commands become available. Can I disable the command
> say 'New Window' using vba? Any help is very much appreciated.

bEnabled = False
' only disable 'New Window'
Application.CommandBars.FindControl(ID:=303).Enabled = bEnabled

' or desable the menu
Application.CommandBars("Document").Enabled = bEnabled
' don't forget to reset these to True

Regards,
Peter T

"Francis Ang" <(E-Mail Removed)> wrote in message
news:3B2C7CC6-63F0-46DF-BD80-(E-Mail Removed)...
> When you click on the Excel icon which appears on the top left hand corner
of
> a workbook, several commands become available. Can I disable the command
> say 'New Window' using vba? Any help is very much appreciated.

Hi Ron, Peter,

Thank you very much for the replies. Really appreciate your advice.

"Peter T" wrote:

> bEnabled = False
> ' only disable 'New Window'
> Application.CommandBars.FindControl(ID:=303).Enabled = bEnabled
>
> ' or desable the menu
> Application.CommandBars("Document").Enabled = bEnabled
> ' don't forget to reset these to True
>
> Regards,
> Peter T
>
> "Francis Ang" <(E-Mail Removed)> wrote in message
> news:3B2C7CC6-63F0-46DF-BD80-(E-Mail Removed)...
> > When you click on the Excel icon which appears on the top left hand corner
> of
> > a workbook, several commands become available. Can I disable the command
> > say 'New Window' using vba? Any help is very much appreciated.
>
>
>