Inserting comments on protected worksheet
 

Hello,

Could someone please advise on how I can insert comments into various
unprotected cells (Column AZ) whilst the worksheet is protected?

When I protected my worksheet, I chose the following:

Tools / Protection / Protect Worksheet and selected (ticked) the Select
unlocked cells check-box only.

The comments I wish to add will only be inserted in those cells in
Column AZ only.

Any help would be greatly appreciated.

Kind regards,

Chris.


Live Long and Prosper :-)

*** Sent via Developersdex http://www.developersdex.com ***

Inserting comments on protected worksheet
 

You also need to allow users to edit objects when you protect the
worksheet

Chris Hankin wrote:
Hello,

Could someone please advise on how I can insert comments into various
unprotected cells (Column AZ) whilst the worksheet is protected?

When I protected my worksheet, I chose the following:

Tools / Protection / Protect Worksheet and selected (ticked) the Select
unlocked cells check-box only.

The comments I wish to add will only be inserted in those cells in
Column AZ only.

Any help would be greatly appreciated.

Kind regards,

Chris.


Live Long and Prosper :-)

*** Sent via Developersdex http://www.developersdex.com ***

Inserting comments on protected worksheet
 

thanks dodgo - very much appreciated.

Cheers,

Chris.

Live Long and Prosper :-)

*** Sent via Developersdex http://www.developersdex.com ***