xlsb file not saving correctly if you print it

[marsh916]

I have been using the attached workbook for a couple of years without any issues. Then IT started switching out desktops and changing us over to Office 2016 and Windows 10. Since then, if you select yes when asked about printing, it does not save the form, it saves the second tab "data". I have been through all pages of the VBA, but I cannot find the problem. Is this just a bug from switching systems? Or has someone changed something and I am just missing it? PW available upon request if needed.

[6StringJazzer]

if you select yes when asked about printing

When I run macro XferData, the form is saved correctly. The version of Excel or OS wouldn't change this. I checked out your code and I am not sure this is the problem but it is a poor coding practice:

Please Login or Register  to view this content.

Do not depend on what sheet is active to take action. If you want to copy the the form use ws_Form instead of ActiveSheet.

[marsh916]

Jeff,
That fixed the problem! I have no idea why it worked for so long, then quit. Thank you for the advice and assistance. Reputation has been added!!!