B
Babs in Ohio
I have 2 worksheets.
One has several Pivot Tables that need to be refresh (but I want to Protect
this worksheet)
The other worksheets has a command button with a macro associated with it to
refresh my Pivot Tables.
My problem is that once I have Protected the worksheet with the Pivot Tables
the Command Button results in a Run-time error '1004': Cannot edit PivotTable
on protected sheet.
Is there a solution to this problem - short of just Format > Sheet > Hide?
One has several Pivot Tables that need to be refresh (but I want to Protect
this worksheet)
The other worksheets has a command button with a macro associated with it to
refresh my Pivot Tables.
My problem is that once I have Protected the worksheet with the Pivot Tables
the Command Button results in a Run-time error '1004': Cannot edit PivotTable
on protected sheet.
Is there a solution to this problem - short of just Format > Sheet > Hide?