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