Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 *** |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 *** |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Inserting comments on protected worksheet
thanks dodgo - very much appreciated.
Cheers, Chris. Live Long and Prosper :-) *** Sent via Developersdex http://www.developersdex.com *** |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Inserting Comments into Cells of Protected Worksheet | Excel Worksheet Functions | |||
Adding comments into a protected worksheet | Excel Discussion (Misc queries) | |||
Inserting Comments in protected worksheets | Excel Discussion (Misc queries) | |||
Inserting Comments into Protected sheet | Excel Discussion (Misc queries) | |||
Protected worksheet and comments | Excel Discussion (Misc queries) |