I am using following 2 lines of code in a subroutine, which creates a pivot table:
Application.CommandBars("PivotTable").Visible = False
ActiveWorkbook.ShowPivotTableFieldList = False
After these lines of code have run, both the command bar and the Field List are still visible, but cannot be selected anymore.
Is there anything you can suggest to try to fix this? I have spend hours trying this and that, but the net result is that nothing changes.
Thanks in advance,
Joop
Application.CommandBars("PivotTable").Visible = False
ActiveWorkbook.ShowPivotTableFieldList = False
After these lines of code have run, both the command bar and the Field List are still visible, but cannot be selected anymore.
Is there anything you can suggest to try to fix this? I have spend hours trying this and that, but the net result is that nothing changes.
Thanks in advance,
Joop
