Excel Macro Security Failing

J

JayCl

winXPsp2, Office2003 sp2. When opening excel spreadsheets via EXPLORER, if
macros security is set to medium, when a second ss is opened it does not give
the macro dialog. When the macros are run on the spreadsheet a warning
indicating the security is to high, or a certificate is missing.
(certificates are not used). If the same two ss are opened via Start->My
Recent Documents. The macro dialog is displayed and works fine.
If the spreadsheets are opened via Excel->File->open then all works ok.
However if the spreadsheets are opened via the Excel->File->Recent file list
the second spreadsheet fails. Any ideas ? This does not happen on all
machines or for all users. The files can be stored locally or on the network.
 

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

Need Help with Macro Security 1
Menu Macro Not Executing - Need Help 1
Excell 2000 macro will not open file! 1
Macro security in 2007 5
Embedded Excel into Word with Tables 0
Word macro that can call cells out of Excel for a find and replace 0
why the macro is not included in the list? 3
Open all Excel spreadsheets/fles before running queries 0

Top