ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel Macro Security Failing (https://www.excelbanter.com/excel-discussion-misc-queries/111992-excel-macro-security-failing.html)

JayCl

Excel Macro Security Failing
 
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.


All times are GMT +1. The time now is 02:27 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com