I have a password-protected workbook that at one point in time I set the "PivotTable Field List" to not be shown. Now I need to make an update to the Pivot Table Fields and the icon shows but it is grayed out. I have tried
"Application.CommandBars("PivotTable Field List").Enabled = True"
but it simply refuses to work.
If I open another spreadsheet with pivot tables, the "PivotTable Field List" button will show up.
A few macros run via workbook_opens (). I have added these. The worksheet protection commands work but the
Worksheets("AppendixA_Out").Unprotect Range("Admin_PW").Value
Application.CommandBars("PivotTable Field List").Enabled = True
Worksheets("AppendixA_Out").Protect Range("Admin_PW").Value, _
AllowUsingPivotTables:=True, AllowFiltering:=True, Userinterfaceonly:=True
I created a test macro with just two instructions,
Application.CommandBars("PivotTable Field List").Enabled = True
MsgBox Application.CommandBars("PivotTable Field List").Enabled
I expect the message box to show "True" but it shows "False". Obviously, Excel is not updating the value of that setting even though I enter the command.
"Application.CommandBars("PivotTable Field List").Enabled = True"
but it simply refuses to work.
If I open another spreadsheet with pivot tables, the "PivotTable Field List" button will show up.
A few macros run via workbook_opens (). I have added these. The worksheet protection commands work but the
Worksheets("AppendixA_Out").Unprotect Range("Admin_PW").Value
Application.CommandBars("PivotTable Field List").Enabled = True
Worksheets("AppendixA_Out").Protect Range("Admin_PW").Value, _
AllowUsingPivotTables:=True, AllowFiltering:=True, Userinterfaceonly:=True
I created a test macro with just two instructions,
Application.CommandBars("PivotTable Field List").Enabled = True
MsgBox Application.CommandBars("PivotTable Field List").Enabled
I expect the message box to show "True" but it shows "False". Obviously, Excel is not updating the value of that setting even though I enter the command.