Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
CommandBars("Insert").Enabled question
Hello,
In my code I want to dissable some menu options so I did: CommandBars("File").Enabled CommandBars("Insert").Enabled .... CommandBars("Window").Enabled All options I want are disabled but the "Insert" is not. There is no error messasge at all. Any idea what is going wrong? If there is any way to make some options invisible would be even beter. I tried CommandBars("Insert").Visible = False but getting message: "Method Visible of object CommandBar failed" Thank you very much Dusan |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
CommandBars("Insert").Enabled question
Dusan,
An example to disable the options in the Tools menu : Application.CommandBars("Tools").Controls("Options ...").Enabled = False It seems that the "Options..." must be given in the language from your Excel version ( in my Dutch system i had to fill in "Opties..." ). You can as well replace the Controls("Options...") with the number (counting from top to bottom) your "options..." take up in the menu. -- Regards, Auk Ales * Please reply to this newsgroup only * * I will not react on unsolicited e-mails * "Dusan" wrote in message ... Hello, In my code I want to dissable some menu options so I did: CommandBars("File").Enabled CommandBars("Insert").Enabled ... CommandBars("Window").Enabled All options I want are disabled but the "Insert" is not. There is no error messasge at all. Any idea what is going wrong? If there is any way to make some options invisible would be even beter. I tried CommandBars("Insert").Visible = False but getting message: "Method Visible of object CommandBar failed" Thank you very much Dusan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
Lost "File Menu" - now it's "Edit / View / Insert.." but no "F | Excel Discussion (Misc queries) | |||
"Disk is Full" add-on question to "Can't reset last cell" post tod | Excel Discussion (Misc queries) | |||
"Toggle total row" button not enabled in Excel 2003 | Excel Discussion (Misc queries) | |||
Insert "-" in text "1234567890" to have a output like this"123-456-7890" | Excel Discussion (Misc queries) |