I have a pre-made form, and I it has a check box with the title "trade for
service" next to it. I need to change that title, and can not get to the
cell to change that. The sheet is unprotected, but I can not change it.

Hi!

The title is part of the checkbox. Depending on what type of checkbox it is
dictates how to change the title.

If it's from the Forms toolbar:

Right click the checkbox.
A menu will appear.
Select Edit Text.

If it's from the Control Toolbox:

Right click on the checkbox
A menu will appear.
Select Properties.
Look for Caption in the left column.
Enter the new "title" in the right column.

Biff

"Linds" wrote in message
...
I have a pre-made form, and I it has a check box with the title "trade for
service" next to it. I need to change that title, and can not get to the
cell to change that. The sheet is unprotected, but I can not change it.

If it's a check box from the Forms toolbar:
Right-click on the check box, and choose Edit Text

If it's a check box from the Control toolbox:
Choose ViewToolbarsControl Toolbox
Click the Design Mode button
Right-click the check box, and choose Properties
In the Caption box, change the text
Click the Exit Design Mode button
Close the Control Toolbox

Linds wrote:
I have a pre-made form, and I it has a check box with the title "trade for
service" next to it. I need to change that title, and can not get to the
cell to change that. The sheet is unprotected, but I can not change it.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html