| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I allow users to fill down on a protected sheet?
I'm trying to set up a workbook on our network for users to enterdata on,
however the sheet needs to be protected. Even if I turn all of the "priviledges" on (give them to the users) in the protection choices, I can't get it to fill down, which will be very important for our users to be able to do. Am I missing something? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I allow users to fill down on a protected sheet?
Hi,
you can protect you workbook and have the cells where the users enter data unprotected Highlight the cell where the data will be entered and then right click in the mouse, format cells, Protection , uncheck locked. then protect your workbook other option will be to set up a password for users to enter to be able to open the sheet "AOEO" wrote: I'm trying to set up a workbook on our network for users to enterdata on, however the sheet needs to be protected. Even if I turn all of the "priviledges" on (give them to the users) in the protection choices, I can't get it to fill down, which will be very important for our users to be able to do. Am I missing something? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Allow users of protected sheet to use macro involving custom filte | Excel Discussion (Misc queries) | |||
| Using fill handle - validated cell - protected sheet | Excel Discussion (Misc queries) | |||
| How do i allow users to insert hyperlinks into a protected sheet | Excel Discussion (Misc queries) | |||
| On protected Excel sheet users be able to group/ungroup rows/colum | Excel Worksheet Functions | |||
| Fill down on a protected sheet | Excel Discussion (Misc queries) | |||
Linear Mode
