View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jack Wood[_10_] Jack Wood[_10_] is offline
external usenet poster
 
Posts: 1
Default macro to redirect to another worsheet within the same workbook


I have a workbook consisting of about 20 or more tabs. The 1st sheet is
titled Index. Looking for a macro that when an item is selected on the
index, you are automatically directed to a specified worksheet & then
need a macro on the specified sheet that will automatically send you
back to the index. I cannot use regular hyperlinks because the workbook
that you input your entries on has to be a copy of the original workbook
& when you make a copy of the original workbook & use a regular
hyperlink to another worksheet, it will send you back to the original
workbook.


--
Jack Wood
------------------------------------------------------------------------
Jack Wood's Profile: http://www.thecodecage.com/forumz/member.php?userid=346
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=101372