Pasword Protecting VBA

[DeaninGA]

Hi All,

Is it possible to password protect only 1 macro/procedure in a Macro Enabled Book with multiple Macros?

Reason: I have one that touches a live DB. I'm not willing to give up that information. But other macros/proceedures will need to be tweaked from time to time.

Thank you in advance
Dean

 

[makiwara]

Maybe convert that macro to an addin?

 

[Logit]

Ayedeal