Assign a password to a macro button?

[caliskier]

I just need something that does not let a macro be run unless a password is intered. It could be an input box I guess, but do now know how to set it up.

[shg]

Like this?

Please Login or Register  to view this content.

[caliskier]

exactly, thanks

[dominicb]

Good afternoon caliskier

Your macro can probably still be seen from the Tools > Macro > Macros dialog box. To get around this make your sub "Private" (just add the word "Prvate" prior to "Sub").

However, it's far better that you incorporate the code shg gave you into the main module.

HTH

DominicB