Private Sub ToggleButton1_Click()
If ToggleButton1.Value = True Then
MsgBox "depressed"
Else
MsgBox "Not depressed"
End If
End Sub

--
Regards,
Tom Ogilvy

"Momo" wrote in message
...
Hello,
Can anyone give me a general idea of how to write code for toggle buttons,
i
don't have a clue where to start for when it is depressed and when it
isn't,
any help please, a sample simple macro or something, i want to use them to
hide, or unhide sheets,

Thanks,

Andy