Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
skip to worksheet
I appreciate your help with this problem:
In A column I have a list of worksheets, on double click on the cell I want to skip to proper worksheet. I have something like this: Private Sub Click() Dim Wk As Worksheet Dim WksName As String For Each Wk In Worksheets WksName = Range(A5).Value Wk.Activate = Wk.Range("A5").Value Next End Sub |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
skip to worksheet
Instead of a list of worksheets in column A, put a list of hyperlinks to the
worksheets. You will: 1. need only a single click 2. be able to specify any cell on each sheet 3. need no VBA -- Gary''s Student gsnu200712 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I skip all these questions? | Excel Discussion (Misc queries) | |||
skip rows | Excel Discussion (Misc queries) | |||
skip printing worksheet | Excel Discussion (Misc queries) | |||
Is there a shortcut to skip down the page in a large worksheet? | Excel Discussion (Misc queries) | |||
Skip the holidays | Excel Discussion (Misc queries) |