LOAD WORKSHEET BY CLICKING ON A CELL

  • Thread starter Thread starter KIRK
  • Start date Start date
K

KIRK

Is it possible to click on a cell and have it load
another worksheet.
I have a workbook with worksheets a-z that im creating
for an reference guide for cad commands
and some of the commands are related to other commands
So I want to be able to click on a cell that would direct
me to the correcct worksheet and possibly to a specific
cell in that sheet. Or would it be better to do a search
for the entire workbook?
 
Here is one I use on a menu worksheet to goto a printed name in a cell or to
a workbook.

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As
Boolean)
Application.DisplayAlerts = False
Dim WantedSheet As String
WantedSheet = Trim(ActiveCell.Value)
If WantedSheet = "" Then Exit Sub
On Error Resume Next
If Sheets(ActiveCell.Value) Is Nothing Then
GetWorkbook ' calls another macro to do that
Else
Sheets(ActiveCell.Value).Select
ActiveSheet.Range("a4").Select
End If
Application.DisplayAlerts = True
End Sub
 
Back
Top