Good afternoon --
I have a template workbook that I want to release to a lot of users. Much
of the template is protected, but I want to add an unprotected page that has
a pivot table, based on a large table on a protected page.

The source data table has one line that's unlocked (the most recent month's
data) but the rest of it is locked and protected.

I have a button-driven macro that unprotects the worksheet, moves the data
to make room for the current month's numbers, then unlocks the current
month's cells and finally protects the worksheet again. What commands should
I try to allow this data to be the source for a pivot table on an unprotected
page?

Thanks in advance.