Thanks for helping, you're right it didn't work.
--
Steve Franks


"LFCFan" wrote:


Hi Steve,

Have you tried:

application.displayalerts = false

NOt sure if that over-rides these kinds of security warnings though. If
it does, be sure to switch the alerts back on afterwards with:

application.displayalerts = true

Probably won't work but worth a shot.

Cheers
Joe


--
LFCFan
------------------------------------------------------------------------
LFCFan's Profile: http://www.excelforum.com/member.php...o&userid=37484
View this thread: http://www.excelforum.com/showthread...hreadid=572117