Hiding Pivot Table Toolbar from a macro

  • Thread starter Thread starter Jack Gillis
  • Start date Start date
J

Jack Gillis

I have recorded several macros to create different pivot tables that I
repeatedly use. When I first recorded
them, I forgot to close the Pivot Table Toolbar
before I stopped recording and it appears each time I run a macro to
create the tables. That was OK
for a while until I had finished modifying the individual macros to
have the tables look just like I want and where I want them.

Now I would like to do away with the Pivot Table Toolbar by code at the
end of each macro. How
to do that is beyond me. Maybe it can't be done but that doesn't stop me
from wanting to do it.

Will someone please help me out here?

Thank you.
 
Whoops! That was too easy once I stopped try to make it hard. Problem
solved with

Application.CommandBars("PivotTable").Visible = False.

Thank you.
 
Back
Top