PDA

View Full Version : Solved: How To Hide Macros In The Alt-F8 Menu...



Wolfgang
08-14-2006, 04:44 AM
Hi all?

I protected my macros in the VBA-Project-Properties environment in order to simply ?hide? them, I know not the best method but it serves its purpose?

Now, how can I also hide them in the Alt-F8 menu because here they all are?

I?m running office 2003 pro ? US-version?

Thank you

Best, Wolfgang

Bob Phillips
08-14-2006, 05:03 AM
Precede the code in each module with


Option Private Module

Wolfgang
08-14-2006, 05:09 AM
Hi Bob...

Really THAT easy?!...figures...

Thank you very much...

Wolfgang