Hello again! Hopefully the last thing to perfect my spreadsheet. I need a macro that will automatically change the scaling of the print job. Because of all of the workups my sales guys do each day, and considering NONE of them are computer savvy, I'd like to see if there's a way to automatically do it for them. In the "Print Preview", under "Page Setup", I would like to change the "scaling" section to go to "Adjust to" and then change it from 100% to 85%. That should cover all of the worksheets and make them all print the way they should. Any ideas? Thanks so much.....this place is AMAZING!!
Bookmarks