View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mats Samson Mats Samson is offline
external usenet poster
 
Posts: 112
Default Return to previous worksheet

Hi,
I have two workbooks (WTNSystem and WTNDatabase) open, with several sheets
in each workbook.
Id 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 arent particularly reliable but maybe there is
a solution?! Furthermore, Id like to keep this code in the hidden
Personal.xls, so the code can be used by any sheet calling it.
Thanks
Mats