hide-unhide

  • Thread starter Thread starter hoysala
  • Start date Start date
H

hoysala

i have written the following code to hide a column

can anybody help me altering the program to swap between hide and
unhide using the same CommandButton ?



Private Sub CommandButton5_Click()

If ActiveSheet.Name = SHEETNAME Then

If Worksheets(SHEETNAME).Columns("c:t").Hidden = False Then
Worksheets(SHEETNAME).Columns("c:t").Hidden = True
End If

End If

End Sub
 
Private Sub CommandButton5_Click()
If ActiveSheet.Name = SHEETNAME Then
Columns("c:t").Hidden = Not .Columns("c:t").Hidden
End If
End If


--
Jim
|i have written the following code to hide a column
|
| can anybody help me altering the program to swap between hide and
| unhide using the same CommandButton ?
|
|
|
| Private Sub CommandButton5_Click()
|
| If ActiveSheet.Name = SHEETNAME Then
|
| If Worksheets(SHEETNAME).Columns("c:t").Hidden = False Then
| Worksheets(SHEETNAME).Columns("c:t").Hidden = True
| End If
|
| End If
|
| End Sub
 
Try a Toggle Button and this.

Option Explicit

Private Sub ToggleButton1_Click()
If ActiveSheet.Name = ("Sheet1") Then

If Worksheets("Sheet1").Columns("C:T").Hidden = False Then
Worksheets("Sheet1").Columns("C:T").Hidden = True

ElseIf Worksheets("Sheet1").Columns("C:T").Hidden = True Then
Worksheets("Sheet1").Columns("C:T").Hidden = False
End If

End If
End Sub

HTH
 
Private Sub CommandButton5_Click()

If ActiveSheet.Name = SHEETNAME Then

If Worksheets(SHEETNAME).Columns("c:t").Hidden = False Then
Worksheets(SHEETNAME).Columns("c:t").Hidden = True
Else
Worksheets(SHEETNAME).Columns("c:t").Hidden = False
End If

End If

End Sub
 
Hi Hoy. :-)
For a very "personal" solution (no Button, etc), try:

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel
As Boolean)
Cancel = True

With ActiveSheet
If .Columns("c:t").Hidden = False Then
.Columns("c:t").Hidden = True
Else
.Columns("c:t").Hidden = False
End If
End With

End Sub

Saluti
Eliano
 
Back
Top