Marcos Disable when Workbook Password is added

C

Carey Campbell

I have a protected the worksheet(s), Saved the File in a Trusted Location,
password protected the VBE and my macros run fine. File is saved as .xlsm The
'Enable marcoes'message does not appear. FINE.

However, as soon as I add a password to the entire WORKBOOK file, save it
and re-open it, The marcos are disabled and no Marco Security box is shown
allowing me to enable macoes ( Which it should not anyway since the file is
in a Trusted Location ) If I go back and remove the WORKBOOK password,
re-save and re-open the Workbook, everyhting is now fine again.

Looking for clues
 
J

Josh C

I am having that exact problem, were you ever able to come up with a
solution? I really would like to password protect my file with marcos.
 

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

Similar Threads

Password protect new workbooks from template 0
Save workbook without shapes 0
Repeated Requests for GSuite password when first Accessing Outlook 365 after system start 0
Open file password 13
Excel is removing Macros from workbook 3
Password locked with macro 1
Outlook Desktop (latest) stopped syncing IMAP accpounts from selfowned Mail server. 0
Sub projects added as read only in Master file which are saved on sharepoint 1

Top