Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro to send you to a specified worksheet
1) why not use hyperlinks?
Option Explicit Sub AddHyperlinks() Dim cell As Range For Each cell In Range("A6:A8") cell.Hyperlinks.Add cell, "", SubAddress:=cell.Value & "!a1" Next End Sub 2) if you have sheet tabs showing, you can right click and select the sheet "Jack Wood" wrote in message ... I have a workbook consisting of about 20 tabs. In this workbook I have a worksheet that is called Index & is an index of all the tabs. On this index list, need a macro for when the item is selected you will be sent directly to that sepcific worksheet. Then once at that specific worksheet I have typed RTN TO INDEX & need a macro on that worksheet when RTN TO INDEX is selected, will return you to the Index. -- 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=101234 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Greate a macro to send worksheet in an email | Excel Discussion (Misc queries) | |||
Macro to send worksheet via email | Excel Discussion (Misc queries) | |||
Send To Worksheet / CSV file | Excel Programming | |||
Can I record or write a macro to send a worksheet via Outlook? | Excel Discussion (Misc queries) | |||
Send data to another worksheet.... | Excel Programming |