| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot table in locked cells
Hi there,
I have a pivot table that I don't want users to alter. However, there is one field that I do want them to access to change the month that the report is to be run for. I have locked all cells except the one containing the field that I do want them access to... obviously this is not the way... Can someone please explain to me how to set security access / locked cells for a pivot table? Thank you! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot table in locked cells
Use VBA
"PsyberFox" wrote: Hi there, I have a pivot table that I don't want users to alter. However, there is one field that I do want them to access to change the month that the report is to be run for. I have locked all cells except the one containing the field that I do want them access to... obviously this is not the way... Can someone please explain to me how to set security access / locked cells for a pivot table? Thank you! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copying values from pivot table to cells outside pivot table | Excel Discussion (Misc queries) | |||
| Pivot Table Cells | Excel Discussion (Misc queries) | |||
| How can I allow users to update a pivot table when it is locked? | Excel Discussion (Misc queries) | |||
| pivot table - cell locked | Excel Discussion (Misc queries) | |||
| Put comments on a locked spreadsheet even though cells not locked | Excel Worksheet Functions | |||
Linear Mode
