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!
|