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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2007 graphs/charts automatically populate with new data 1
Adding Report Filters to Excel Pivot Tables via VB. 1
Pivot Chart - negative values not displaying properly 2
Pivot Chart Data Labels 5
Dynamic Range Chart and Ignoring Zeros 3
Pivot table report invalid 0
PIVOT - Using a cell outside the table for change the grouping 11
Pivot Chart Row and Column Headers 2

Back
Top