it worked when i tested it (excel 2000 win xp) using a control toolbox
checkbox....... i just changed the coding to checkbox1 to match my
checkbox.
maybe you are using a forms checkbox?
susan


On Oct 23, 1:58*pm, Charlie wrote:
i have a check box with that code in it but it does absolutely nothing when i
check it or uncheck it, no error, no column hiding nothing.

-Charlie



"FSt1" wrote:
hi
i just plugged your code into my 2003 and it works??????
what problems are you haveing with it.

regards
FSt1

"Charlie" wrote:

Any Reason why this does not give error or a response? I built it with help
from this forum and everything seems right. Im stumped.

Im using office 2003.
______________________

Private Sub CheckBox20_Click()

If CheckBox20 = True Then
* * Columns("G").Hidden = True
Else
* * Columns("G").Hidden = False
End If

End Sub- Hide quoted text -

- Show quoted text -