Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,670
Default How to enable macro and updated link without confirmation?

Does anyone have any suggestions on how to enable macro and updated links
automatically without pop up any window for confirmation?
Therefore, I don't need to click twice for opening a worksheet.
Does anyone have any suggestions?
Thanks in advance for any suggestions
Eric

  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 248
Default How to enable macro and updated link without confirmation?

Excel 2003
Tools-Options-Edit Tab
Clear the check box 'Ask to update automatic links'

Tools-Options-Security Tab-'Macro Security' button
Select 'Low' radio button

Be aware that these settings make you vulnerable to macro based threats...

--
Pl click the YES button
(if you see it - don''''''''t worry if you don''t),
if this answer was helpful.



"Eric" wrote:

Does anyone have any suggestions on how to enable macro and updated links
automatically without pop up any window for confirmation?
Therefore, I don't need to click twice for opening a worksheet.
Does anyone have any suggestions?
Thanks in advance for any suggestions
Eric

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to find out how long it's been since a link updated GuinnessT Excel Worksheet Functions 1 October 28th 08 10:27 AM
Why the link cannot be updated? Eric Excel Worksheet Functions 0 March 8th 08 05:19 PM
how the link of Excel is updated automatically using workgroup LAN Excel link updated through LAN workgroup Excel Discussion (Misc queries) 1 October 22nd 06 03:30 PM
Link cannot be updated LarryP Setting up and Configuration of Excel 1 December 6th 05 11:55 PM
Link not being updated.... brian ferris Excel Discussion (Misc queries) 1 May 3rd 05 02:08 PM


All times are GMT +1. The time now is 10:12 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"