| Home |
| Search |
| Today's Posts |
|
#2
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 |
| 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) | |||
Threaded Mode
