View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
michaelberrier michaelberrier is offline
external usenet poster
 
Posts: 63
Default Unchecking all Forms checkboxes in entire sheet

I found this great code for unchecking all Form Toolbar created
checkboxes on a single sheet:


Sub Clearem()
Dim bx as object
For each bx in Worksheets("Sheet1").Checkboxes
bx.value = xlOff
Next
End Sub

How can I adapt this to uncheck all boxes in an entire workbook? I've
tried Activebook and workbook("") with no luck.

Thanks in adavnce.