View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
tom tom is offline
external usenet poster
 
Posts: 570
Default Check Box Status

I have about 10 Check Boxes on a sheet that I built using the Control
Toolbar. When I check the box on and off, I don't want to have a macro do
anything at that time.

Instead, I want to write a separate macro, that when I click the button will
go and check the status of each of the checkboxes and then do something (such
as print a sheet).

In other words, this overall macro would run a "batch" and perform a print
function based upon the state of each CheckBox.

Any ideas?