Thank you. This works when I step through it, but I get a
run time error every time I click the togglebutton on the
sheet.

Unable to set hidden property of range class

Any ideas how to get around this?