Multiple Worksheets to set up for print in page setup
I have over a hundred worksheets in my workbook. I have to change each worksheet to 69%, legal size, change all margins to 0 and set to landscape. Is there a formula or something that you can use so that you can set up all worksheets at once to save that page set up?
Im not sure if this will work, but give it a try. Group all teh sheets you want to print, 1st, then select print.
To group, clikc on the 1st sheet tab, then hold the shift key and click on the last sheet (if you have sheets that are not consecutive, use CTRL instead of/as well as shift)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
uh oh....I did that and now, when I go to print preview on the next sheet after the first one, it takes me to preview the first one and I can't make it show me anything further. Now, what do I do..
Check this out
http://www.howtoexcelatexcel.com/exc...le-worksheets/
I did what it said, three times, but it didn't work.
Thank you for your help though!
Oh, okay...wait, it works if you hit Shift and select the worksheets like fdibbins said...YEAH, thank you both!!
Happy to help and thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
,
Bookmarks