LinkBack URL
About LinkBacks
Hi friends
I hope you are doing well
I have a work from sheet named 2 to 211. I need to set all at once to be printed in landscape orientation,scale 80% and print area from B2:Q10
Thanks much I believe someone will help to make my work easy
Hi friends
I hope you are doing well
I have a work from sheet named 2 to 211. I need to set all at once to be printed in landscape orientation,scale 80% and print area from B2:Q10
Thanks much I believe someone will help to make my work easy
Why not use the Macro Recorder ? Just active the recorder, manually do once all the settings and you will have your macro ready for use.
Then all you will have to add is a For/Next to cycle all your sheets.
Last edited by rollis13; 11-09-2022 at 07:28 PM.
I don't know more about micro my be you can help me
let me attach my document and you can help me
Go to File > click on print > in setting select > print entire workbook.
atul
If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.
Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".
Select all sheets you need, and in page setup select the orientation, margins, and print area. And than print all sheets at once
Diana Tanase
If the solutions offered helped you to solve your problem, then mark the thread as SOLVED (thread tools in the top menu) and you can click on * to add reputation to those who helped you, as a way to say thank you !
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks