BeforeSave event

[Jon]

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

 

[Bob Phillips]

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)