Maybe you could use Jan Karel Pieterse's utility:
http://www.jkp-ads.com/Download.htm
Look for GoBack.Zip



Graham Haughs wrote:
>
> Is it possible in a multi-sheet workbook to create a procedure to jump
> back to the sheet and the place you were in previously, ie without using
> the tabs to move about. If you were in sheet 6 for example and moved by
> a macro to Sheet 20, is there a way to identify that you have just been
> in sheet 6 and use a macro to be linked to a command button for example
> to jump back to it. Hope this is well enough explained and I would be
> grateful for any guidance.
>
> Kind regards
> Graham Haughs
> Turriff, Scotland

--

Dave Peterson