Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to find out how long it's been since a link updated | Excel Worksheet Functions | |||
Why the link cannot be updated? | Excel Worksheet Functions | |||
how the link of Excel is updated automatically using workgroup LAN | Excel Discussion (Misc queries) | |||
Link cannot be updated | Setting up and Configuration of Excel | |||
Link not being updated.... | Excel Discussion (Misc queries) |