Running Macros in a hidden workbook

[webtouch]

Dear Experts,

I have created macros and saved them in a workbook. The macros will be run from other workbooks while this one is hidden. To prevent any unauthorised changes on the macros, I would like to keep the workbook with macros hidden with my password.

Please tell me how I can do this.

 

[Zack Barresse]

Hi webtouch, welcome to the board!

Not sure what you mean, but you can password protect your VBA project so nobody can view your modules .. VBE | Tools | VBA Project Properties | Protection (tab), set password.

Note that if/when you set a VBA password, you will not be prompted for the password until the file is closed (& saved) and reopened again.

 

[webtouch]

Hi Firefytr,

You have done me good!

It is not exactly what I had in mind, but it works like it all the same.

Thank you so very much