View Updated Chart

  • Thread starter Thread starter MBlake
  • Start date Start date
M

MBlake

Hi,
I have a pivot table that drives a performance chart. I have the pivot
table worksheet protected by a password. I have a macro that displays the
performance chart to a user. However the chart will not correctly update as
the pivot table is password protected. is there a way around this?

I have tried writing a macro that unprotects the pivot table and refreshes
the data, however when run the macro asks the user for the password.

Mickey
 
Unprotects the pivottable worksheet???

If yes, then you could have your code supply that password:

worksheets("sheet1").unprotect password:="topsecret!"
'your code here
worksheets("sheet1").protect password:="topsecret!"
 
Back
Top