|
Turning off questions
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. -- Peter London, UK |
Turning off questions
Here's the code, maybe you could place it in the workbook open module Application.AskToUpdateLinks = False -- davesexcel ------------------------------------------------------------------------ davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708 View this thread: http://www.excelforum.com/showthread...hreadid=563975 |
Turning off questions
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 "Peter" wrote: 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. -- Peter London, UK |
Turning off questions
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! -- Peter London, UK "Ron Coderre" wrote: 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 "Peter" wrote: 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. -- Peter London, UK |
Turning off questions
No. It can't be done, if it could, virus writers would have a field day!
Regards, Alan. "Peter" wrote in message ... 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! -- Peter London, UK "Ron Coderre" wrote: 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 "Peter" wrote: 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. -- Peter London, UK |
Turning off questions
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 StartProgramsMicrosoft OfficeOffice Tools and build a selfcert from there. When complete and your workbook is open go to VBEditor and ToolsDigital SignatureChoose. 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 wrote: 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 "Ron Coderre" wrote: 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 "Peter" wrote: 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. -- Peter London, UK |
Turning off questions
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 "Gord Dibben" wrote: 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 StartProgramsMicrosoft OfficeOffice Tools and build a selfcert from there. When complete and your workbook is open go to VBEditor and ToolsDigital SignatureChoose. 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 wrote: 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 "Ron Coderre" wrote: 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 "Peter" wrote: 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. -- Peter London, UK |
Turning off questions
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 On Sat, 28 Apr 2007 12:42:02 -0700, Andy Sarno wrote: 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 "Gord Dibben" wrote: 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 StartProgramsMicrosoft OfficeOffice Tools and build a selfcert from there. When complete and your workbook is open go to VBEditor and ToolsDigital SignatureChoose. 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 wrote: 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 "Ron Coderre" wrote: 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 "Peter" wrote: 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. -- Peter London, UK |
Turning off questions
Thank you so very much, It worked
Andy "Gord Dibben" wrote: 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 StartProgramsMicrosoft OfficeOffice Tools and build a selfcert from there. When complete and your workbook is open go to VBEditor and ToolsDigital SignatureChoose. 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 wrote: 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 "Ron Coderre" wrote: 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 "Peter" wrote: 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. -- Peter London, UK |
| All times are GMT +1. The time now is 11:13 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com