How do I insert a comment in unlocked cell of a protected workshee

T

TD_Anne

I have created timecards for our employees which have protected formula cells
for daily and period totals. The rest of the cells are unlocked and
emploiyees used to insert comments to remind themselves and/or inform
accounting as to what they worked on. We are now using 2003 and the comment
option is unavailable. How can I make it available again? This is an
important tool for us.
 
G

Gord Dibben

TD_Anne

When protecting the sheet, check the box at "Edit Objects" and you can insert
comments into unlocked cells.


Gord Dibben MS Excel MVP
 
T

TD_Anne

YES!!!!!! It worked. Thank you. I never thought of a cell in the worksheet
as an "object" so didn't think to try that.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Inserting comment in unlocked cell of protected Excel worksheet? 1
How do I put a formula into an unlocked cell on protected workshee 1
Can I add a "Comment" to an unlocked cell in a protect worksheet 4
I want to insert a picture in an unlocked cell of a protected shee 2
Insert/ delete row in protected worksheet 6
Excel 2002 "Protect Sheet", but Allow "Insert Comments"? 2
As soon as I protect my sheet, I can no longer insert comments... 2
add comments in unlocked cell of protected worksheet 1

Top