adding comments to protected sheet

G

Guest

I would like to know if I can add comments to a sheet that is protected.
Although the sheet is protected the cell is not locked. Can this be done?
 
G

Gord Dibben

DMT

With Excel 2002 and 2003 there is an option when protecting the sheet to "Edit
Objects"

Checkmark that option.


Gord Dibben MS Excel MVP
 

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

Protected Worksheets and Comments 1
Macro functions in a protected sheet 4
Excel Move or Copy Stopped Working? 0
Allow comments to be added to protected worksheet? - Excel 2007 1
Excel Protection 2
Insert Comments on a Protected Worksheet 1
Sorting tables on protected worksheets 7
Protected Sheets 2

Top