Possibility for "sub" worksheets?

  • Thread starter Thread starter Chanda Cole
  • Start date Start date
C

Chanda Cole

Is it possible to create "sub worksheets" within a
worksheet in Excel? I have a workbook with multiple
worksheets, one for each customer. The worksheet is
intended to provide summary information for the customer.
What I'd like to do is provide some type of link
(hyperlink, button, etc) from the summary worksheet
allowing the user to "drill down" to more detailed
information on various topics. I'd like to keep one
worksheet per customer and have "sub worksheets" for this
detailed information, but am at a loss as to how to do
that. Any ideas / suggestions are welcome!
 
You could do what I saw recently.
Hide the tabs>create a custom toolbar that had menus on it to list the subs
with links to click. OR, you could have a menu sheet with typed in names and
just use a doubleclick event.

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

'I created this which might be better than above
'Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As
Boolean)
'Dim mysheet As String
' mysheet = Trim(ActiveCell.Value)
' On Error GoTo no
'Sheets(mysheet).Select
'Exit Sub
'no: MsgBox "No Sheet"
'End Sub
 
Chanda Cole said:
Is it possible to create "sub worksheets" within a
worksheet in Excel? I have a workbook with multiple
worksheets, one for each customer. The worksheet is
intended to provide summary information for the customer.
What I'd like to do is provide some type of link
(hyperlink, button, etc) from the summary worksheet
allowing the user to "drill down" to more detailed
information on various topics. I'd like to keep one
worksheet per customer and have "sub worksheets" for this
detailed information, but am at a loss as to how to do
that. Any ideas / suggestions are welcome!
Click to expand...

I don't think you can do a "sub worksheet" but you might find Group and
Outline under the Data menu to be of use.

HTH
 
Back
Top