How do I hide an Excel MENU item?

  • Thread starter Thread starter Marcello do Guzman
  • Start date Start date
M

Marcello do Guzman

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("Macros...").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: (e-mail address removed)
 
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 said:
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("Macros...").Delete
I want to be able to use the TOOLS, MACRO, but not the MACROS which
Click to expand...
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
Click to expand...
placing the above code in ThisWorkbook.
 
Back
Top