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:

Set mnubrWorksheet = MenuBars(x1Worksheet)
MenuBars(x1Worksheet)).Menus("Tools").MenuItems("M acros...").Enable =
False

The above is supposed to "grey" the MACROS menu item so that you
cannot view the MACROS LIST, but will allow you to access the Visual
Basic Editor.

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

Please post answer here on the microsoft.public.excel programming
newsgroup or reply via email: