Text Box within protected doc question

[lightecho]

When I create a report and protect the sheet for locked cells (users can select unlocked cells) how can I keep a text box for comments unaffected by the protection?

Thanks
Dave

[ChemistB]

With the sheet unprotected, right click on the text box and select "Format Text Box" Go to the Protection Tab and make sure "Locked" is checked and "Lock Text" is not checked. Click OK and then protect your spreadsheet.

ChemistB

[lightecho]

I didn't realize there was a 'format text box' with more than just the 'font' tab. One must right click on the box edge and not in the middle!

[mikerickson]

Another option is to not check the Objects box in the Protect Dialog.