Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to Disable Customize PopUp Window
Hi
when I right click the blank area on the File Menu, a window pops up from which I can then select/deselect things such as Standard, Format etc and at the bottom Customize and there the Command tab which allows me drag icons such as SaveAs to the File Menu to enable saveas event if it was previously greyed out thru procedure. How do I disable or not show this popup window in vba. Many thks KZ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to Disable Customize PopUp Window
Hi Kieranz,
Try: Application. CommandBars("ToolBar List").Enabled = False --- Regards, Norman "Kieranz" wrote in message oups.com... Hi when I right click the blank area on the File Menu, a window pops up from which I can then select/deselect things such as Standard, Format etc and at the bottom Customize and there the Command tab which allows me drag icons such as SaveAs to the File Menu to enable saveas event if it was previously greyed out thru procedure. How do I disable or not show this popup window in vba. Many thks KZ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to Disable Customize PopUp Window
Hi Kieranz,
Deleting the inadvertent space, try: Application.CommandBars("ToolBar List").Enabled = False --- Regards, Norman |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to Disable Customize PopUp Window
Thks All
Great help. Rgds KZ Norman Jones wrote: Hi Kieranz, Deleting the inadvertent space, try: Application.CommandBars("ToolBar List").Enabled = False --- Regards, Norman |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Disable the "customize" window | Excel Programming | |||
Disable Customize option in toolbar | Excel Programming | |||
Disable Customize in Excel 10,11 | Excel Programming | |||
Disable Customize in Excel 10,11 | Excel Programming | |||
Disable Customize in Excel 10,11 | Excel Programming |