I have an Excel spreadsheet that uses VB to watch for entries in certain
cells. At times an 'aduit' feature is triggered to write entries to a
protected sheet.

There are a couple of these I woudl like to ensure get saved without
further intervention.

I see there is a SaveAs function that could do this - but is there the
equivalent to simply save the current worksheet back as the same
filename that was used to open it? Ie the equivalent of clicking the
Save Disc icon.

Regards
Clive


--
ccarmock
------------------------------------------------------------------------
ccarmock's Profile: http://www.excelforum.com/member.php...o&userid=27670
View this thread: http://www.excelforum.com/showthread...hreadid=497154