Peo,

That's what I did. I created the check box and then edited it's properties
so that I could tell it where to place the value so that I could create a
formula based on it's results. As soon as I change any of the properites of
the check box, security views it as a "custom" macro.

Thanks,
Dean

"Peo Sjoblom" wrote:

Use the checkbox from the forms toolbar instead


Regards,

Peo Sjoblom

"Maverick2U" wrote:

I'm trying to create a simple check box that returns a value into a cell (for
instance A1). I create the check box and put A1 in the "LinkedCell" section
under Properties. This places a TRUE or FALSE into A1. Now every time I open
the spreadsheet I have to chose to enable macros. If I share this file whit
others who have high security settings, they won't even be able to open it.
This file is going to unsophisticated users and this simple check box may
make it so that they can't even use the file. Is there a way to fix it so
that this isn't seen as a "custom" macro?

If I create a check box but have the value of the check box appear nowhere
on the sheet, the security does not bother it.

Thanks.