Excel VBA Code

  • Thread starter Thread starter Cindy
  • Start date Start date
C

Cindy

Please help!

I have an Excel 2000 template that suddenly displays this
message when opening:

The macros in this file do not match the digital
signature. Only a macro with a virus would cause this.
Please scan for viruses.

As a company, we run TrendMicro OfficeScan, which doesn't
appear to detect macro viruses.

Any ideas how I can "save" this file? I do have a backup
but it's two days old. Thanks!

Cindy
..
 
Hi Cindy,
The macros in this file do not match the digital
signature. Only a macro with a virus would cause this.
Please scan for viruses.

As a company, we run TrendMicro OfficeScan, which doesn't
appear to detect macro viruses.

Any ideas how I can "save" this file? I do have a backup
but it's two days old. Thanks!
Click to expand...

If you can still open the file, try going to the VBE and removing the
digital signature (Tools menu).

Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com
 
Thanks Jan,

I was able to remove the digital signature, but how do I
know if this template really contains a virus?

When I put the signature back, it appears to be ok.

Cindy
 
Hi Cindy,
I was able to remove the digital signature, but how do I
know if this template really contains a virus?
Click to expand...

Viruses in Excel VBA are relatively rare. Any up to date scanner should
catch them if present. So I would try to scan this particular file. If
none found I suspect you should be safe.

Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com
 
Back
Top