MACRO HELP

[Neil Holden]

Morning, i have an excel workbook to automatically open at a specified time,
i have code to run a macro to and close the excel sheet after a certain time.

The trouble i'm having is when the excel opens its asking to update links
YES or no, is they anyway i can automatically update the links instead of
having to press yes?

Thanks,

 

[Mike H]

Hi,

Tools|Options|Edit

Un-check 'Ask to update links'

Mike

 

[Mike H]

Or for 2007

Office button|Excel options - Advanced and scroll down and un-check

Mike