View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Return to previous worksheet

You would need to instantiate Application Level events and then keep track
of what sheets/cells were selected. Rather than put bottons on sheets, you
could use a floating toolbar.

See Chip Pearson's page for basic information on Application.Level events

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

--
Regards,
Tom Ogilvy


"Mats Samson" wrote in message
...
Hi,
I have two workbooks (WTNSystem and WTNDatabase) open, with several sheets
in each workbook.
I'd like to create a Return-buttons in the sheets that takes me back to

the
previous sheet, even if it was in the other workbook. The originating

sheet
can be different each time too.
I know that Public variables aren't particularly reliable but maybe there

is
a solution?! Furthermore, I'd like to keep this code in the hidden
Personal.xls, so the code can be used by any sheet calling it.
Thanks
Mats