Cannot Refresh Pivot Tables
 

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?
--
Babs