Run Macros in a Password-protected workbook?

J

JRSCEI

I have an excel worksheet which has several macros associated with it.
However the workbook is password protected and so when I open the file, the
macros are automatically disabled. Excel says "you can't run macros that
can't be scanned by the appropriate virus scanning software". Since I wrote
the macros I know they are OK. I've tried setting the Trust Setting to
"enable all Macros" but it still does not allow me to run the a macros
without deleting the password protection on the file. Any ideas? Thanks.
 

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

unpassword macros 3
problem with macros and protections 5
problem with macro setting 1
How to Unlock Excel Workbook protected by MACRO Password 6
Excel 2007 enabling macros 3
Excel files - macros & links 4
How to stop running macros everytime I run excel? 1
Password protected Excel File 1

Top