BeforeSave event
 

Hello all,

I have a Check box in my a sheet calledheckbox1.

I also have an event called Workbook_BeforeSave. How do I check the
value of the checkbox from this event?

Thanks all,

Jon

BeforeSave event
 

If Worksheets("Sheet1").CheckBoxes("Check Box 1").Value = 1 Then
Msgbox "It is set
...

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Jon" wrote in message
ups.com...
Hello all,

I have a Check box in my a sheet calledheckbox1.

I also have an event called Workbook_BeforeSave. How do I check the
value of the checkbox from this event?

Thanks all,

Jon