Workbook Protectionand stiil use Comment function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a shared workbook that requires some fields to be used for data entry
and some fields for comments ( using the Xl comment function), however, when
I protect the workbook the overall comment function is also looked (still
allows viewing a previous comment). Is it possible to overcome this scenarion
so that one doesn't have to Unprotect the book or sheet everytime a comment
needs to be inserted or edited.

Many thanks

Olympiad
 
In Excel 2003 you can edit comments in protected sheet, if you check the
option for Edit Objects in the Protect Sheet dialog.
 
And in versions before xl2002 (xl2002 has the same dialog as xl2003), there's a
checkbox that can be checked when the worksheet is protected.
 

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

Can I protect data in a cell, but allow comments to be entered. 6
Protected Workbook 1
possible to record vba editing as a macro 5
automatic date entry in XL cell.. 3
Insert Comment is disabled 2
Comments in a shared Workbook acting strangely 1
Inserting Comments In A Shared Workbook 4
Adding comments into a protected worksheet 6

Back
Top