Command Buttons properties changing after export to PDF

[dentler]

I am using the following code to export visible excel sheets to a pdf. After it run all the activex command buttons have shifted locations and size. If I close the WB without saving then they return to their normal location and size. Does anyone have any ideas what may be causing this or how to fix it? I have tried stopping screen updates and saving the WB before the code runs but it still occurs. Help???

"Sub ExportAsPdf()
Dim FolderPath As String
Dim FName As String
Application.ScreenUpdating = False 'Stop Screens from updating while running code
Call SaveWB

Sheets("Baseline").Select
FName = "Finance" & Range("M38").Value

'Folder Path set to active users profile My Docments folder
FolderPath = Environ$("UserProfile") & "\My Documents\"
'MsgBox (FolderPath)
'MsgBox (FName)
'MkDir FolderPath

'Export all visible sheets
For Each ws In Sheets
If ws.Visible = -1 Then
ws.Select Not flg
flg = True
End If
Next
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:=FolderPath & "\" & FName, _
openafterpublish:=False, ignoreprintareas:=False

'MsgBox ("all PDFs have been sucessfully exported.")

Application.ScreenUpdating = True
End Sub
"

[kasan]

Hi,
Good practise here is to use code tags.

To avoid button size and location change try:
- right click on a button, choose Format Control
- on a tab Properties select "Don't move or size with cells"

[xlnitwit]

Hi,

It is a common problem for activex controls on worksheets to change size and position- usually following a display or printer change, which I suspect exporting to PDF is related to. If at all possible, I would recommend replacing the activex buttons with either Form controls or shapes.

[dentler]

I found out that when I run this in Excel 2016 it works fine, but when I run it in excel 2010 then it fails with the original problem of relocating the command buttons. I have not tested it on any other versions yet.

[dentler]

It also works on office 2013, so somewhere along the lines they fixed it. If you have to move to another version, I would suggest 2013, Office 2016 has too many issues and I get multiple errors when trying to run the same program on 2016. If you search the web, the opinions on 2016 are not at all favorable.

[dentler]

Ok, so after several days of trying to resolve this problem and trying many suggestion that I found online, I decided to bite the bullet and upgrade to Office and Excel 2013. I preferred it over 2016, there are just too many thumbs down discussions around problems with 2016. In any case this solved my problem and the activex controls are fine now after printing or exporting to a pdf file.

[dentler]

So, after purchasing office 2013 and recreating the ActiveX command buttons which did resolve the problem, I now have found that if I take that back and run it in 2010, it still works. So I spent a little bit of money to learn that I could have perhaps recreated the buttons on another system running 2013 and that would have resolved my problem.

[Logit]

You can send me your new version of Excel .... just saying