protection of pivot table

  • Thread starter Thread starter ampm
  • Start date Start date
A

ampm

How can i protect my pivot table against writting on the fields, but I
want to able filter that fields ?

thanks
 
You can protect the worksheet programmatically as the workbook opens:

Private Sub Workbook_Open()

With Worksheets("Sheet4")
.EnablePivotTable = True
.Protect Password:="password", _
Contents:=True, UserInterfaceOnly:=True
End With
End Sub


This will prevent users from typing in the worksheet cells, but they
would be able to change the field names by right-clicking on a field
button and choosing Field Settings.
 

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

how to partially protect a pivot table based worksheet 8
Refreshing Pivot Table on a protected spreadsheet tab 1
Protect part of pivot table 1
prevent pivot tables / charts from editing 1
2003 Pivot Table Filter (items dropped in the Page Fields) 1
Single Filter to change all Pivot Tables in a Workbook 8
pivot table data 2
Multiple listboxes to update pivot table? 2

Back
Top