Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I hide an Excel MENU item?
I would like to hid the Macros menu list in the TOOLS, MACRO, MACROS
menu in Excel so that people will not be able to edit my macros. I have been using the following code, but it simply does not work: MenuBars(ThisWorkbook).Menus("Tools").MenuItems("M acros...").Delete I want to be able to use the TOOLS, MACRO, but not the MACROS which displays the MACRO list box. I want to be able to use the Visual Basics Editor which is a sub menu of the TOOLS, MACRO menu item. Need the price VBA coding and where I should place it. I have been placing the above code in ThisWorkbook. What I am I doing wrong? Thanks, Marcello Post reply via email: |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I hide an Excel MENU item?
Marcello?,
In the module containing your macros... place "Option Private Module" at the top of the module. It will change color if it is entered properly. This will hide the display of the macro names in the Macros list box. Regards, Jim Cone San Francisco, CA "Marcello do Guzman" wrote in message ... I would like to hid the Macros menu list in the TOOLS, MACRO, MACROS menu in Excel so that people will not be able to edit my macros. I have been using the following code, but it simply does not work: MenuBars(ThisWorkbook).Menus("Tools").MenuItems("M acros...").Delete I want to be able to use the TOOLS, MACRO, but not the MACROS which displays the MACRO list box. I want to be able to use the Visual Basics Editor which is a sub menu of the TOOLS, MACRO menu item. Need the price VBA coding and where I should place it. I have been placing the above code in ThisWorkbook. What I am I doing wrong? Thanks, Marcello Post reply via email: |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
creating my own menu item in excel | Excel Discussion (Misc queries) | |||
Adding a menu item to Excel | Excel Discussion (Misc queries) | |||
Control item PRINT in menu FILE of Excel | Excel Discussion (Misc queries) | |||
Excel 2000 Custom Menu Item | Excel Discussion (Misc queries) | |||
Menu items added with menu item editor in older versions | Excel Discussion (Misc queries) |