Making a Hide/Unhide Toggle button

  • Thread starter Thread starter Souljah
  • Start date Start date
S

Souljah

Can someone tell me how to do one of these?

I want it to just hide a particular column when toggled down and unhid
when toggled up, and also, automatically hide the respective column o
startup of the workbook.
thanks for any hel
 
Toggle:

Public Sub ToggleHiddenColumn()
With Columns(1)
.Hidden = Not .Hidden
End With
End Sub

hide at start:

Private Sub Workbook_Open()
Worksheets("Sheet1").Columns(1).Hidden = True
End Sub
 

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

Back
Top