Dear all,
i'm writing a small software for my company using excel vba.
i accomplished everything but i'm facing a problem with the UserForm.PrintForm.
I created a button and wrote inside it the simple "UserForm1.PrintForm"
1: i can't print my form on paper, all i get is a save as PDF.
2: when i save it as PDF, my form is positioned on the top left on an A4 paper
what i want to do is:
1: is it possible to print directly my form on a paper or it should be saved as a PDF then i go print it from PDF?
2: can i center my form to be in the middle of the PDF A4 paper?
3: is it possible to hide the buttons of commands i added to my UserForm1 like "exit, print" button so when print it, i only have the complete form without the buttons and after this the buttons show back?
thank you
P.S. i tried the worksheet print it worked very good, but the boss is insisting on the form, he doesn't want the sheet.