Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
disable control | Excel Programming | |||
disable control | Excel Programming | |||
Disable Excel Control | Excel Programming | |||
Disable Excel Control | Excel Programming | |||
Disable Control s | Excel Programming |