View Updated Chart

[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

 

[Dave Peterson]

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!"

 

[MBlake]

Thanks Dave,
I'll try the suggestion, much appreciated.

Mickey