Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro to send you to a specified worksheet
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro to send you to a specified worksheet
drop a hyperlink on a sheet thats targetting the index sheet . and then just
copy/paste to the other sheets "Patrick Molloy" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro to send you to a specified worksheet
Hyperlinks will not work because to complete items in the workbook you have to make a copy of the original file & rename it to the Well's Project name. We do not let the Engineer use the original file for any entries. When you make a copy of the file the hyperlink sends you back to the original file. -- 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro to send you to a specified worksheet
On May 28, 3:50*pm, Jack Wood
wrote: *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. Perhaps put this code in the ThisWorkbook module? Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Range) If Target.Value = "RTN TO INDEX" Then Application.Goto Sheet1.Range("A1"), True End If End Sub |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro to send you to a specified worksheet
On May 29, 11:11*am, andy the pugh wrote:
On May 28, 3:50*pm, Jack Wood wrote: *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. Perhaps put this code in the ThisWorkbook module? Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Range) * * If Target.Value = "RTN TO INDEX" Then * * * * Application.Goto Sheet1.Range("A1"), True * * End If End Sub Oops, that crashes with a multi-select. Use: Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Range) If Target.Cells(1, 1).Value = "RTN TO INDEX" Then Application.Goto Sheet1.Range("A1"), True End If End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
macro to send you to a specified worksheet | Excel Programming | |||
Greate a macro to send worksheet in an email | Excel Discussion (Misc queries) | |||
Macro to send worksheet via email | Excel Discussion (Misc queries) | |||
Send worksheet by E-Mail | Excel Discussion (Misc queries) | |||
Can I record or write a macro to send a worksheet via Outlook? | Excel Discussion (Misc queries) |