Saving current workbook
 

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

Saving current workbook
 

Thisworkbook.Save

or

ActiveWorkbook.Save

--
Regards,
Tom Ogilvy

"ccarmock" wrote in
message ...

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

Saving current workbook
 

Tom,

Many thansk - that worked perfectly.

Clive


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