Excel 2003: Turning off virus message

[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

 

[Frank Kabel]

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]

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:

http://www.contextures.com/xlfaqMac.html#NoMacros

to remove the modules from the workbook. That should stop the message
from appearing.

 

[Richard Evans]

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:

Ah. I have some keyboard macros in it.

Dick

 

[Richard 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

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

 

[Richard 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'.

Nuts. That didn't do it.

Dick

 

[Gord Dibben]

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

 

[Richard Evans]

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

Did that, created my own certificate.

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

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]

RE: I have security set to "low" and still get the warning message

What exactly does the message say?

***** Posted via: http://www.ozgrid.com
Excel Templates, Training & Add-ins.
Free Excel Forum http://www.ozgrid.com/forum *****

 

[Richard Evans]

RE: I have security set to "low" and still get the warning message

What exactly does the message say?

"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

 

[Gord Dibben]

Richard

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

Gord Dibben Excel MVP

 

[Richard Evans]

Richard

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

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

 

[Gord Dibben]

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

 

[Richard Evans]

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

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