Disable control
 

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.

Disable control
 

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

Disable control
 

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

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

Regards,
Peter T

"Francis Ang" wrote in message
...
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.

Disable control
 

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).Enabl ed = bEnabled

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

Regards,
Peter T

"Francis Ang" wrote in message
...
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.