How to enable macro and updated link without confirmation?

  • Thread starter Thread starter Eric
  • Start date Start date
E

Eric

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
 
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...
 
Back
Top