If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed.
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.
"ccarmock" <ccarmock.20wsoy_1136040301.7008@excelforum-nospam.com> wrote in
message news:ccarmock.20wsoy_1136040301.7008@excelforum-nospam.com...
>
> 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
>
Linear Mode
