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!

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!