Yes but I find staff tend to click no to open the spreadsheet quicker, I
wanted a to guarantee the updating of spreadsheets everytime it is
open.

Can a macro be written to automaticall choose yes?


--
DKerr
------------------------------------------------------------------------
DKerr's Profile: http://www.excelforum.com/member.php...o&userid=13087
View this thread: http://www.excelforum.com/showthread...hreadid=565487