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

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

Guest

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.
 
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
 
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
 
You must log in or register to reply here.

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

changing font using conditional formatting 1
Hide/Unhide worksheets upon entries in a range of the main worksheet 5
How to hide rows in an Excel worksheet based on a variable 2
Macro to hide worksheet based upon text in the name 5
How do I auto hide a row if a condition isnt met? 1
Hiding Rows 10
Hiding rows or columns based on cell contents 3
Macro to hide sheets based upon cell value 3

Back
Top