skip to worksheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cursor to upper left of frozen cells (in macro) 11
New Tab Debug 1
append multiple worksheets data into a single multi-dimensional array 4
Copy a range data from 1 sheet to multiple selected sheets 1
Match a value to multple criteria both in rows and columns 3
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
How to copy & paste a worksheet but change 1 bit of the formula? 1
Excel VBA 1

Back
Top