EXCEL 2007 Macro Security Being Ignored

L

Libby H

I have a certificate signed macro that users access and create data files
from. When some of my users migrated from Excel 2003 to Excel 2007, I
provided instructions on how to 'enable' the content of the macro.

I have one user using Excel 2007 that doesn't receive the security warning
allowing them to 'enable' the macro. When accessing the spreadsheet with
macro, it asks if you want to open it, but then automatically disables the
macro. We have tried modifying the 'trust center' options for macros and it
still doesn't work. When we changed the security from 'disable all macros
with notification' to 'enable all macros' nothing changed.

This user had installed a custom add-in - I am wondering if that might have
disrupted the security settings. Can anyone tell me if/where I could look in
the register to see if security has been disabled?
 
E

Eduardo

Hi,
file has to be saved as Excel Macro-Enable (xlsm), it happens to me when
sending to the user the file as xls the macro didn't work, ask for the file
to save as I told you
 
E

Eduardo

Hi,
file has to be saved as Excel Macro-Enable (xlsm), it happens to me when
sending to the user the file as xls the macro didn't work, ask for the file
to save as I told you
 
L

Libby H

Appreciate everyone's suggestions.
Appears that the other custom EXCEL add-in was preventing the warning
message from appearing. The app team of the custom add-in was able to make
modifications to allow the warning message to appear. So, all's well that
ends well! Thanks again.
 

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