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
gvilbisAsked:
Who is Participating?
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Connect With a Mentor Microsoft MVP ExcelCommented:
Hello,

in the File > Save dialog, click the Tools dropdown > General Options.

You can enter a password here. There are two kinds of workbook password, one you need to enter to open the file and another one you can set up for people to edit the file.

You can also use password protection on the VBA project. That dialog is in the VBE, though.

cheers, teylyn
0
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
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.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.