Running Macros in a hidden workbook

webtouch

New Member
Joined
Dec 2, 2005
Messages
8
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.
 

Some videos you may like

Excel Facts

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().

Zack Barresse

MrExcel MVP
Joined
Dec 9, 2003
Messages
10,881
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
  2. Mobile
  3. Web
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

New Member
Joined
Dec 2, 2005
Messages
8
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
 

Watch MrExcel Video

Forum statistics

Threads
1,118,435
Messages
5,572,085
Members
412,441
Latest member
kelethymos
Top