Quick one ...
Can someone tell me the code for disabling automatic refresh when a workbook is loaded ?
i.e. The code equivalent of clicking the "disable automatic refresh" button.
Thanks :)
Printable View
Quick one ...
Can someone tell me the code for disabling automatic refresh when a workbook is loaded ?
i.e. The code equivalent of clicking the "disable automatic refresh" button.
Thanks :)
Never mind .. I got it !
(,False after workbook open statement)
TBO,
Would you mind sharing your solution?
Thanks,
Peter
Welcome to the Forums.
He posted it in #2. During your .Open statement you pass the False parameter for "UpdateLinks". :)