Refresh Pivot chart on protected sheet

Hi I have a pivot table and Pivot chart that are on one sheet. It was working fine but When I have protected my sheet That shows error

"Pivot table can not refreash on protected sheet..."

I have used following VBA code as follows

Please Login or Register  to view this content.

I have used Me.Protect userinterfaceonly:=True but still no success
http://www.mrexcel.com/forum/showthread.php?t=481591