I don't think you can save a single sheet without exporting it out of
the workbook. I suppose you could have a linked sheet that saves
statically on a timer in the background though...
--
patrickcairns
------------------------------------------------------------------------
patrickcairns's Profile:
http://www.excelforum.com/member.php...o&userid=31790
View this thread:
http://www.excelforum.com/showthread...hreadid=515154