Link to home
Start Free TrialLog in
Avatar of gvilbis
gvilbis

asked on

How do i set password protected when openning excel 2007 Macro file?

i would like that every user that opening excel 2007 file it will ask him to insert password, how do i do that?

Thanks
ASKER CERTIFIED SOLUTION
Avatar of Ingeborg Hawighorst (Microsoft MVP / EE MVE)
Ingeborg Hawighorst (Microsoft MVP / EE MVE)
Flag of New Zealand image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
If you want to protect the VBA code with a password, open the VBE, right click on the project and select Properties. You can set a password on the Protection tab.