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


On Fri, 4 Mar 2005 07:53:09 -0800, "kitepuppet"
<kitepuppet@discussions.microsoft.com> wrote:

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