how return to last used sheet?

[Rolando]

Hi there!

in a worksheet_activate event I test a number of variables and then ask the
user if it want to continue. If not, the user should come back to the sheet
it came from, "the previous visited". The "previous method" doesn't work
since it take you back to the previous sheet "in index". The user have 10
sheets that could be the previous visited.

what method should I use?

Regards!

 

[Tom Ogilvy]

You would have to use the workbook level events to set a variable to hold
the last sheet the user was on.

See Chip Pearson's page on Events:

http://www.cpearson.com/excel/events.htm

 

[Bob Phillips]

Rolando,

I think you need to manage it yourself. Add this to THisWorkbook, and then
you can use the variable PrevSeet, but note that you will need
ThisWorkbook.PrevSheet from your code.

Public PrevSheet As String

Private Sub Workbook_Open()
PrevSheet = ActiveSheet.Name
End Sub

Private Sub Workbook_SheetDeactivate(ByVal Sh As Object)
PrevSheet = Sh.Name
End Sub

--

HTH

RP
(remove nothere from the email address if mailing direct)