hiding the macro menus

[cmefly]

hi,

i've created a program with multiple macros.

I want to hide the macro pulldown menu and macro toolbar.

i've got this code to hide the tool bar:

Application.CommandBars("Visual Basic").Enabled = False

but how do i hide the pulldown menu found under TOOLS-->MACROS

any ideas?

 

[VoG]

If you declare your subs as Private they won't show up in the menus

Private Sub MyMacro()

 

[cmefly]

wow...i have a ton of macros...


so if i go into each module and put the word "private" before sub for each one....i won't have a problem...??


some macros call other macros....this is okay? do you foresee any issues?

 

[VoG]

I can't foresee any issues.

 

[cmefly]

can i use this code to hide the pulldown menu...

Application.CommandBars("Visual Basic").controls ??? i just don't know how to use this properly....i'm googling options and this came up....

 

[VoG]

I'm not sure but don't forget that you'd need to disable ALT +F8 as well (and there might be other shortcuts).

In the VBE you can use Edit > Replace and replace Sub with Private Sub

 

[cmefly]

okay....i'll do what you said...


i found out that this: Application.CommandBars("Tools").Controls("Macro").Delete works well...

wonder how to get rid of shortcut??? hmmmm...