Protect A Pivot Table

  • Thread starter Thread starter Celtic_Avenger
  • Start date Start date
C

Celtic_Avenger

I'm back with another query!

I need to protect a pivot table so that users cannot alter any detail
on the page, but also allow the table to refresh using VBA activate
buttons.

I could use the protect command in the macro of the button that take
the user to the table, and then unprotect when they leave to allo
future refreshes, But.....

IS THERE A SIMPLER METHOD
 
Refreshing a pivot table, for the most part, is an overt act. What causes
the table to refresh? If you are using code to do it, why not just
unprotect the sheet, refresh the table, protect the sheet.
 
You must log in or register to reply here.

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

Pivot Table drilldown and protecting workbook 1
Pivot tables wont work in protected sheet? 3
Pivot Table based on data in protected cells 1
Pivot Table Question 2
Pivot tables not refreshing after data source update 1
Multiple Worksheets Protection 1
Pivot Tables - refresh from Userform command button 2
Refreshing Pivot Table on a protected spreadsheet tab 1

Back
Top