Erm... lost! How do I get toggle buttons to work. From what I can gather, VB needs to know what to do when the button is pressed down or lifted up. How to I formulate it?
This is what happens when I press it down:
How do I get it to "..hidden = True" to work when I lift the button?
Thankyou
This is what happens when I press it down:
Code:
Private Sub ToggleButton1_Click()
Sheets("Holland").Select
Range("D:D,H:H,L:L,P:P,T:T,X:X,AB:AB,AF:AF,AJ:AJ,AN:AN,AR:AR,AV:AV").Select
Range("AV1").Activate
Selection.EntireColumn.Hidden = False
Sheets("Holland").Select
Range("A1").Select
End Sub
How do I get it to "..hidden = True" to work when I lift the button?
Thankyou