Excel 2003: Turning off virus message

  • Thread starter Thread starter Richard Evans
  • Start date Start date
R

Richard Evans

In an Excel 2003 spreadsheet, I have a hyperlink to a file on my
computer. When I click it, I get a warning about possible viruses that
I have to dismiss before the file opens. The title bar identifies it
as an Office message, not a Norton AntiVirus message. How can I turn
it off?

Dick Evans
 
Hi Dick
this is a security FEATURE of Office/Excel. you may setting the
security level to 'Low': Goto 'Tools - Macros - Security' and choose
'Low'.

Note: This disables a security feature! -> be careful doing this
 
Debra Dalgleish said:
That message is an indication that the file contains macros, or
contained macros at some point. If you have deleted macros, and still
see the message, you can follow the instructions here:
Click to expand...

Ah. I have some keyboard macros in it.

Dick
 
Frank Kabel said:
Hi Dick
this is a security FEATURE of Office/Excel. you may setting the
security level to 'Low': Goto 'Tools - Macros - Security' and choose
'Low'.

Note: This disables a security feature! -> be careful doing this
Click to expand...

I understand, but I'm the only user of the computer and Norton checks
everything coming and going. Furthermore, the file in question is one
that I created myself.

Dick
 
Frank Kabel said:
Hi Dick
this is a security FEATURE of Office/Excel. you may setting the
security level to 'Low': Goto 'Tools - Macros - Security' and choose
'Low'.
Click to expand...

Nuts. That didn't do it.

Dick
 
Richard

If file is for your use only, check out "self cert" in Help.

You can run Self Cert from the Start>Programs>MS Office>MS Office Tools

Then see Help on "certificates" and "add a digital certificate to a file or
VBA project".

Gord Dibben Excel MVP
 
Gord Dibben said:
Richard

If file is for your use only, check out "self cert" in Help.

You can run Self Cert from the Start>Programs>MS Office>MS Office Tools
Click to expand...

Did that, created my own certificate.
Then see Help on "certificates" and "add a digital certificate to a file or
VBA project".
Click to expand...

This seems to be a way to add the certificate to the worksheet, which
doesn't have any effect on the file I'm opening from within the
worksheet. I have security set to "low" and still get the warning
message. Shouldn't I be adding the certificate to the suspect file?

Dick
 
Dave Hawley said:
RE: I have security set to "low" and still get the warning message

What exactly does the message say?
Click to expand...

"Some files can contain viruses or otherwise be harmful to your
computer. It is important to be sure this file is from a trustworthy
source. Would you like to open this file?"

Dick
 
Richard

Yes. Add the certificate to the "suspect" file's VBA Project in VB
Editor>Tools>Digital Signature.

Gord Dibben Excel MVP
 
Gord Dibben said:
Richard

Yes. Add the certificate to the "suspect" file's VBA Project in VB
Editor>Tools>Digital Signature.
Click to expand...

I'm sorry, but I have no idea what this means. I have no VBA projects.
The file in question has some keyboard macros set through an add-on
called QuickKeys. I assume those are the "macros" that Excel is
objecting to. The file itself is in a proprietary format produced by a
specialized piece of software used for indexing books, a program
called Cindex. There are no provisions in either Cindex or QuickKeys
for adding digital signatures.

Dick
 
Richard

Assumption was made by most(all?) of us that you were talking about an Excel
file you were hyperlinked to.

I have no idea how to deal with third-party apps like QuickKeys.

Suggest you check the documentation on QuickKeys.

Alternative. Is there any way you can alter the Cindex file to *.txt or
something Excel can read and leave the QuickKeys macros behind?

Gord
 
Gord Dibben said:
Alternative. Is there any way you can alter the Cindex file to *.txt or
something Excel can read and leave the QuickKeys macros behind?
Click to expand...

That would defeat the purpose of trying to open it from Excel. I want
to be able to launch Cindex from Excel by clicking on the file name.

Anyway, it's only one file and I probably won't use it that often, so
I guess It's not worth spending any more time on.

Thanks for the help.

Dick
 
Back
Top