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?