Excel Bug after Printpreview by vba? anyone exp this before?

[radian89]

Hi All,

I use excel 2016 in Windows 10

i managed to use some vba code here to do this routine :
1. Hide formula bar & Display heading

    ActiveWindow.DisplayHeadings = False
    Application.DisplayFormulaBar = False

2. Hide ribbons

CommandBars.ExecuteMso "HideRibbon"

3. Hide Sheet tabs

ActiveWindow.DisplayWorkbookTabs = False

this is to lock all the sheets i had & make it user interface bigger. then i have this code for print preview

Sub printpreview()

ActiveSheet.printpreview


End Sub

for each sheets, i put "print preview" button there. once i click print preview it goes normal then after i export it to pdf, it become messed up, all is messed up, even the pdf exported is messed up.

BEFORE i click print preview

AFTER i click print preview

THERE'S UNIQUE CONDITION HERE :
it only happened when i use all the 3 routines i mentioned above.
while if we do it without these 3 routines is all okay.

any suggestion/exp like this before guys? if yes, what should i do? how to overcome this? and why this is happen

thanks so much


- Adrian -

 

[mole999]

turn off the print preview before printing, layout issues do occur, especially were the font is off standard

 

[radian89]

turn off the print preview before printing, layout issues do occur, especially were the font is off standard

well, thanks for the suggestion but print preview here for review it before printing, i guess this step can't be skipped. have any other ideas?