Turning off questions

P

Peter

When my workbook is linked to another, Excel always asks if I want to update
the link upon opening the workbook. Can I turn off this question, so Excel
always updates without asking? In the same way can I stop it asking about
enabling macros when I open a work book conatining a macro, so that the macro
is alway enabled without asking. Many thanks.
 
D

davesexcel

Here's the code, maybe you could place it in the workbook open module

Application.AskToUpdateLinks = Fals
 
R

Ron Coderre

1: Turning off the prompt to refresh automatic links

From the Excel main menu:
<tools><options><edit tab>
UNcheck: Ask to update automatic links

2: Engage macros without asking
Now wouldn't that competely undermine the whole purpose of prompting the
user that's intended to prevent malicious code from running automatically?

Does that help?
***********
Regards,
Ron

XL2002, WinXP
 
P

Peter

I see your point Ron, but I'm trying to develope easy to use applications,
where untrained users do have to worry about answering any questions. Are you
saying it can't be done, or it's just not for publication!
 
A

Alan

No. It can't be done, if it could, virus writers would have a field day!
Regards,
Alan.
 
A

Andy Sarno

Thank you for solving my "Turning off the prompt to refresh automatic links".
This was driving me CRAZY.

Could you help me with another problem? Once I click on a hyperlink I keep
getting asked "Some files may contain a virus do I still want to open this
File"? My answer is always going to be yes.

Andy
[email protected]
 
G

Gord Dibben

Andy

Have a look at this KB Article for disabling that "some files may contain
viruses" message in Office 2003

http://support.microsoft.com/kb/829072/en-us

For the macros warning, if just for your own use on your computer, you can use
the SelfCert tool to create a certificate that sets the macros in a workbook to
"Trusted" and does not display the macros warning.

Check out Help on Digital Signing and the the Self-Cert utility which allows you
to sign your projects on your own computer only.

Self-cert digital signatures are not exportable as are paid-for ones from Thawte
and Versisign.

Go to Start>Programs>Microsoft Office>Office Tools and build a selfcert from
there.

When complete and your workbook is open go to VBEditor and Tools>Digital
Signature>Choose.

Select the one you just created and Ok your way out.

Save the workbook and re-open. Click "Yes" when asked about "trusted whatever".

You won't see the macro message again for that workbook.


Gord Dibben MS Excel MVP



On Sat, 28 Apr 2007 10:18:01 -0700, Andy Sarno <Andy
 
A

Andy Sarno

Thank you so much.
I have one last problen left with Excel 2003.
When I click on a hyperlink to a file, I get this "Microsoft Office" message
window that says "some files contain viruses, etc. Would you like to open
this file?" so, I click Yes and the file opens.
Can you make a 70 year old guy happy so he can get some sleep and will stop
pulling out the little hair left on his head?

Thank you,
Andy Sarno
[email protected]
 
G

Gord Dibben

Andy

Did you read the KB Article on how to disable that message?

If so, what step is giving you trouble?

Working with the Registry?


Gord

Thank you so much.
I have one last problen left with Excel 2003.
When I click on a hyperlink to a file, I get this "Microsoft Office" message
window that says "some files contain viruses, etc. Would you like to open
this file?" so, I click Yes and the file opens.
Can you make a 70 year old guy happy so he can get some sleep and will stop
pulling out the little hair left on his head?

Thank you,
Andy Sarno
[email protected]
Click to expand...
 
A

Andy Sarno

Thank you so very much, It worked
Andy

Gord Dibben said:
Andy

Have a look at this KB Article for disabling that "some files may contain
viruses" message in Office 2003

http://support.microsoft.com/kb/829072/en-us

For the macros warning, if just for your own use on your computer, you can use
the SelfCert tool to create a certificate that sets the macros in a workbook to
"Trusted" and does not display the macros warning.

Check out Help on Digital Signing and the the Self-Cert utility which allows you
to sign your projects on your own computer only.

Self-cert digital signatures are not exportable as are paid-for ones from Thawte
and Versisign.

Go to Start>Programs>Microsoft Office>Office Tools and build a selfcert from
there.

When complete and your workbook is open go to VBEditor and Tools>Digital
Signature>Choose.

Select the one you just created and Ok your way out.

Save the workbook and re-open. Click "Yes" when asked about "trusted whatever".

You won't see the macro message again for that workbook.


Gord Dibben MS Excel MVP



On Sat, 28 Apr 2007 10:18:01 -0700, Andy Sarno <Andy
Click to expand...
 
Top