Unwanted dialogue box

G

George Gee

Hi all

I have a Hyperlink in an Excel worksheet, that opens an application.
When I click on it, a warning dialogue box appears to ask me if I wish
to open/run the file/application.
Well of course I do! I designed the ruddy spreadsheet didn't I?
I think I know that if I click on something that *I* put there that it
does not contain a virus!

Is there any way to turn off this annoying warning?

Thanks for your help.

George Gee
 
D

David McRitchie

Hi George,
Toolls, Macros, Security, Security Level (tab), Medium

is what I have mine set to.
 
G

Gord Dibben

Excel 2002 on "medium" still gives the warning and allows user to decide.

"High" wil not open any workbook containing a macro without a signed
certificate from a trusted source. Automatically disables macros if not
signed.

"Low" will allow any workbook with macros to open without a warning.

You can use the SelfCert tool to create certificates for your own use.

Gord Dibben Excel MVP
 
G

George Gee

GD & DM

Thanks for the responses, although my question still remains
unanswered.
I do not wish to run a macro.
I wish to open an application via a link, but I get an annoying
dialogue box waning me of potential viruses etc..

It is this warning I want to get rid of, not the enable/disable macros
on opening a workbook.

Thanks

George Gee



*Gord Dibben* has posted this message:
 
G

Gord Dibben

George

You mean like the warning I get if I attempt to open a file attachment in this
News Group?

Sorry. Don't know how to suppress that. Probably Windows settings.

Gord
 

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