I have done this in various ways but the technique I use is to do the
checking and copying in a seperate spreadsheet. So I have Main.xls and
Main_partB.xls Main checks the xla's and does the copying then launches
Main_partB.xls and closing itself down.

Usually I set the startup routine in Main_partB.xls to indicate that it
can't be run from here.


Sometimes it is better to do call them Main.xls and Maintenance.xls. In
this case you always run main.xls as before. In this Main.xls checks to
see whether copying is required. If it is then it starts up
Maintenance.xls and closes itself down. Maintenance.xls then does the
copying and can relaunch main.xls.

I find the first to be best when the copying is required most times and
the second to be best when only occaisionally. Also try and keep the non
launchable part in a subfolder so that it is not quite so tempting for a
user.

I use the same technique for keeping the spreadsheets themselves up to
date.

Hope this helps


--
tony h
------------------------------------------------------------------------
tony h's Profile: http://www.excelforum.com/member.php...o&userid=21074
View this thread: http://www.excelforum.com/showthread...hreadid=488625