Hi,
I have a spreadsheet with button controls and pivot tables and charts, after I do an export (one of the macro's), i hide the button controls using:
ActiveWorkbook.DisplayDrawingObjects = xlHide
Which actually hides all controls including the Pivot charts, is there a way I can enable them back and still keep rest of the controls hidden?
Bookmarks