Don't think so, it needs to work on the window. You could use Sendkeys to
close it down after.
--
HTH
Bob Phillips
(remove nothere from the email address if mailing direct)
"John Vickers"
wrote in message
news:John.Vickers.23c0qm_1140109801.1115@excelforu m-nospam.com...
Ok, I got this to work, but when I run the macro, it shows the vb
editor. Is there a command to disable this so it will just run in the
background without showing what it changed?
John Vickers
--
John Vickers
------------------------------------------------------------------------
John Vickers's Profile:
http://www.excelforum.com/member.php...o&userid=31551
View this thread: http://www.excelforum.com/showthread...hreadid=512923