use the click event of the checkbox.

--
Regards,
Tom Ogilvy

"TOMB" wrote in message
...
Windows 2000; Excel 2000

I am using several checkbox controls (format control and
cell link) to toggle a cell's value between 'True'
and 'False'.

I would like to hide or unhide rows based on these cells.

Any suggestions besides using AutoFilter?

Thanks in advance.