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

--
Regards,
Tom Ogilvy

"Rolando" wrote in message
...
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!