how to hide section of worksheet based on a condition (e.g. tick .

K

kitepuppet

I need to hide a section of a worksheet to make it more simple to understand.
But I also want to display the hidden sections if needed , preferably by
ticking a box?
Any ideas? Thanks in advance.
 
J

Jason Morin

Here's a simple example. If the user double-clicks A1,
then the column G thru J will hide/unhide.

Private Sub Worksheet_BeforeDoubleClick(ByVal Target _
As Range, Cancel As Boolean)
If Not Intersect(Me.[A1], Target) Is Nothing Then
If Me.[G:J].EntireColumn.Hidden = True Then
Me.[G:J].EntireColumn.Hidden = False
Else
Me.[G:J].EntireColumn.Hidden = True
End If
End If
End Sub

---
To use, right-click on the worksheet tab, go to View
Code, and paste in the code above. Press ALT+Q to return
to Excel.

HTH
Jason
Atlanta, GA
 
G

Gord Dibben

kite

Make a custom view(or many) in View>Custom Views.

Add a macro to your workbook...

Sub Show_Hidden()
ActiveWorkbook.CustomViews("hidden").Show
End Sub

Assign to a button.


Gord Dibben Excel MVP
 
Top