Removing Macro Virus Warnings Upon File Open

  • Thread starter Thread starter Wendy
  • Start date Start date
W

Wendy

I've got a file where upon opening it, it always gives the
option to enable or disable the macro. It has a macro I
created that is safe, so I want to remove this option.

I've tried to:

1) Change the macro security (It's on Medium) The file
won't save when I select anything else....

2) Checked Always Trust Source/Add-Ins

3) Looked into digital signature. We don't have one that
is certitified, so I don't have one to assign.


We do have virus detection and the macro security
indicates that we don't. (This is an XP compatability
issue from what I've read)

Thanks ahead to anyone having ideas that can help. : )
 
look for a program SelfCert.exe on your computer.

if it's not there..
rerun Office Installation select Change
add or remove Features
goto Office Shared Features and Select
Digital Signatures for VBA Projects


it will install SelfCert.

once it's installed just run it and create your own DigSig.




keepITcool

< email : keepitcool chello nl (with @ and .) >
< homepage: http://members.chello.nl/keepitcool >
 
I have an add-in that creates a menu. One of the menu
items opens a workbook with macros. No matter what my
security settings, Excel doesn't notify me that the
workbook I'm opening contains macros, and it doesn't ask
me if I want to enable them. The macros are enabled
automatically. Is this normal? Any ideas why this
happens?
 
Back
Top