Hello All,
Im trying to do something here I cant quite figure out. Im trying to add a print button to a userform. But three things that have to happen when the button is clicked:
1. Excel has to tell the print dialogue box to ensure the page will only fit on one page by one page
2. The print dialogue box has to pop up so the user can ensure the settings of the print
3. Right now when the print happens scroll bars are printing from the userform. I need those to disappear
This code in its current state is messing with me, it appears I set it to one page by one page but yet when the print happens its only printing the last part of my userform. And right now it also does trigger the dialogue box so that part is solved. I just cant figure out why its not resizing to one page by one page. Any thoughts?
Code:
Bookmarks