Password protected files with macros in 2007 version

C

Carolina Contreras

I need to password protect an excel file with macros in the Excel 2007
version but when I save with a password, it automaticaly disables the macros.
Is this an issue that can be solved? And how?
 
S

ShaneDevenshire

Hi,

To password protect a file you choose
Office Button, Save As, Excel Macro Enabled Workbook, you then click the
Tools drop down to the left of the Save button and General Options, you then
enter a Password to Open and click OK, you confirm the password and click OK,
then Save.
If you are password protecting using another method that may be your problem.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top