| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I lock a worksheet while allowing users to add comments?
Hi,
I'm creating a budget system for several departments that will link together. I need the users to be able to enter data, but not change the form of the sheet -- which I figure out. The trouble is that the users also need to be able to enter comments in the individual cells, and I can't seem to find a way to unlock that function. I'm using Excel 2003. Any help would be appreciated! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I lock a worksheet while allowing users to add comments?
When you protect the sheet, make sure you allow the user to edit objects.
Kidspirit wrote: Hi, I'm creating a budget system for several departments that will link together. I need the users to be able to enter data, but not change the form of the sheet -- which I figure out. The trouble is that the users also need to be able to enter comments in the individual cells, and I can't seem to find a way to unlock that function. I'm using Excel 2003. Any help would be appreciated! -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel - how about allowing colored worksheet tabs for organizing | Excel Worksheet Functions | |||
| Protect Workbook vs Worksheet?? | Excel Worksheet Functions | |||
| How do I automatically show all comments on a seperate worksheet? | Excel Discussion (Misc queries) | |||
| In a protected worksheet allow users to delete rows | Excel Worksheet Functions | |||
| Can I lock a set of cells in a worksheet? | Excel Discussion (Misc queries) | |||
Linear Mode
