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.
 

Excel Facts

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.

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
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,163,998
Messages
5,834,808
Members
430,322
Latest member
excelnoobnoob

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top