I don't understand the significance of selecting the desired sheet before or
after the save. If that doesn't matter, then put a statement like:
Sheets("SheetName").Select
in the Before_Save macro. The file will be saved and that sheet will be the
active sheet.
If it is significant that the sheet selection take place after the save,
then use the same Before_Save macro, set Cancel to True at the start of the
macro, then save the file, then set the save flag to True, then select the
sheet. Something like:
Cancel = True
Application.EnableEvents = False
ThisWorkbook.Save
ThisWorkbook.Saved = True
Application.EnableEvents = True
Sheets("SheetName").Select
Post back with more detail if this doesn't work for you. HTH Otto
"kev_06" wrote in
message ...

Is there any kind of method/event/procedure I can use so that I can make
a sheet appear directly AFTER saving the book? I've trieed manipulating
the beforesave event but didn't get the results I wanted.


--
kev_06
------------------------------------------------------------------------
kev_06's Profile:
http://www.excelforum.com/member.php...o&userid=35046
View this thread: http://www.excelforum.com/showthread...hreadid=550078