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

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.
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.
 
Upvote 0
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
 
Upvote 0

Forum statistics

Threads
1,214,713
Messages
6,121,042
Members
449,006
Latest member
cthorne1

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
Back
Top