Hello,
I'm trying to create a VBA macro button with following code.
Purpose would be to have a printpreview of certain tabsheets in my excel (not every tabsheet needs to be print previewed).
Tabsheet 'Dashboard' and 'Prestations' are visible, tabsheet 'volume' is not visible, but hidden (not via VBA).
Tabsheet volume contains out of a pivottable which needs to be refreshed before the print.preview, however if I run following code it doesn't refresh the pivottable while having the printpreview.
Thanks,
Cara
Bookmarks