If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Add comment in protected worksheet
Can we add a comment for cells in a protected worksheet. I wanted to allow
feature to only add comment and not allow user to do any other modifications |
#2
|
|||
|
|||
Add comment in protected worksheet
EXCEL 2007
Yes. To achieve take the following actions:- 1. Home / Cells group / click on downwards facing arrow in Format / Protect Sheet / Protect Sheet window should launch / in here the following 3 fields should have a tick in them:- Protect worksheet and contents of locked cells Select locked cells Select unlocked cells 2. Add a tick to the following field:- Edit objects OK 3. To test try and enter data into any cells of the Protected Sheet (you should not be able to do this). 4. Shift F2 in any cell / comments pane opens / insert comment / click in another cell / comment goes in successfully. Save file. If my comments have helped please hit Yes. Thanks. "Suju Thomas" wrote: Can we add a comment for cells in a protected worksheet. I wanted to allow feature to only add comment and not allow user to do any other modifications |
#3
|
|||
|
|||
Add comment in protected worksheet
Select all cells.
FormatCellsProtectionLock all cells. ToolsProtectionProtect Worksheet. Allow users to...........select locked and unlocked cells, edit objects. Add a password if you want. Gord Dibben MS Excel MVP On Wed, 17 Mar 2010 10:59:01 -0700, Suju Thomas Suju wrote: Can we add a comment for cells in a protected worksheet. I wanted to allow feature to only add comment and not allow user to do any other modifications |
#4
|
|||
|
|||
Add comment in protected worksheet
Sorry, forgot to mention that you need to put a password in after you select
Edit objects OK / and then put the password in again and hit OK. "trip_to_tokyo" wrote: EXCEL 2007 Yes. To achieve take the following actions:- 1. Home / Cells group / click on downwards facing arrow in Format / Protect Sheet / Protect Sheet window should launch / in here the following 3 fields should have a tick in them:- Protect worksheet and contents of locked cells Select locked cells Select unlocked cells 2. Add a tick to the following field:- Edit objects OK 3. To test try and enter data into any cells of the Protected Sheet (you should not be able to do this). 4. Shift F2 in any cell / comments pane opens / insert comment / click in another cell / comment goes in successfully. Save file. If my comments have helped please hit Yes. Thanks. "Suju Thomas" wrote: Can we add a comment for cells in a protected worksheet. I wanted to allow feature to only add comment and not allow user to do any other modifications |
Thread Tools | |
Display Modes | |
|
|