Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

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

Posted on 2011-09-13
2
Medium Priority
?
263 Views
Last Modified: 2012-08-13
i would like that every user that opening excel 2007 file it will ask him to insert password, how do i do that?

Thanks
0
Comment
Question by:gvilbis
  • 2
2 Comments
 
LVL 50

Accepted Solution

by:
Ingeborg Hawighorst (Microsoft MVP / EE MVE) earned 2000 total points
ID: 36532733
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
 
LVL 50
ID: 36532742
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

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

After seeing numerous questions for Dynamic Data Validation I notice that most have used Visual Basic to solve the problem. This suggestion is purely formula based and can be used in multiple rows.
Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

580 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question