Hi,
I have the following code that works fine except cells that I want "locked" are not locked. I can't find the "select unlocked cells" property as I'm a novice. How do you perform this with VBA code in Excel 2010? Cell A1 is the date being pulled from Worksheets(2) and I don't want the user to be able to change it when they run the pivot table report.
Any help will be appreciated Thanks!
Sub RefreshMonthlySummaryPivotTables()
Dim Pi As PivotItem
Worksheets(3).Unprotect "pass"
Application.ScreenUpdating = False
With ActiveSheet.PivotTables("PivotTable1").PivotFields("Level")
For Each Pi In .PivotItems
If Pi.value = "1" Or Pi.value = "1-P" Or Pi.value = "1-HI" Or Pi.value = "2" Or Pi.value = "3" Or Pi.value = "4" Or Pi.value = "X" Or Pi.value = "X-OS" Or Pi.value = "X-TM" Then
Pi.Visible = True
Else
Pi.Visible = False
End If
Next Pi
End With
Application.ScreenUpdating = True
ActiveSheet.PivotTables("PivotTable1").RefreshTable
Worksheets(3).Protect "pass", AllowFiltering = True, AllowUsingPivotTables = True
End Sub
Bookmarks