Check Boxes

J

Jeff

Hi,

I wrote a 2 macros and these run when you click on check box A or B.

One does a calculation with inflation and another without inflation.

I wanted to put the checkboxes on a form. But I want the form to be
permanently embedded on the sheet, because I think it would look nicer. I
tried putting the checkboxes on a "image" from the control toolbox, but this
didn't work.

Do you have any suggestions?

Thanks
 
F

Frank Stone

hi,
all of what you have mentioned are objects and objects sit
on top of the sheet and are not part of the sheet.
check boxes can be add to forms(embedded if that is the
correct term) but the form cannot be embedded into the
sheet. nor can a check box control be added to a image
control. adding the check boxes to a form is probably best
but the form will "float" on the sheet.
Sorry.
Regards
Frank
 
D

Dave Peterson

Maybe you could put them in Row 1.

Then with A1 visible, select A2 and then Window|freeze panes.

They'll always be visible. You could even use pictures and assign each macro to
one of the pictures.
 
Top