"reset" macro

[singingsister]

I have a large spreadsheet with a variety of macro "buttons" to hide various columns to only show certain data. What I need is to create a "reset" button, that is to say for which ever macro button someone has pressed, if they press the "reset" one, it will unhide all the columns.

How do I do it? Do I need to do a "reset" macro for each existing macro - to show the hidden columns or can I have one "reset" button that will show all regardless of what macro has been used.

 

[pcc]

Cells.EntireColumn.Hidden = False

should do it

 

[stuartford]

does the macro need to unhide only the last lot of hidden items or all hidden items?

if its the latter just record a macro that unhides all within the current sheet

hope this helps

Stuart

ie
Cells.Select
Selection.EntireColumn.Hidden = False
Selection.EntireRow.Hidden = False

 

[Andrew Poulsom]

This will unhide all columns:

ActiveSheet.Cells.EntireColumn.Hidden = False

Maybe you should change your existing macros so that they toggle the hidden property. Example:

Private Sub CommandButton1_Click()
    With Columns("C:D")
        .EntireColumn.Hidden = Not .EntireColumn.Hidden
        If .EntireColumn.Hidden = False Then
            CommandButton1.Caption = "Hide columns"
        Else
            CommandButton1.Caption = "Unhide columns"
        End If
    End With
End Sub

 

[singingsister]

Thanks!