jantea.marius
New Member
- Joined
- Sep 15, 2011
- Messages
- 1
Hi there!
I have an excel missunderstanding. It is about VBA programming and printing size limits.
I have done a little tool in VBA - excel macro, that adjusts the page margins (top, bottom, left, right, header and footer).
It is very useful (at least for me) because the user can select as many files as he wants and this tool will adjusts all the sheets from those documents.
You can insert also header / footer values into the documents.
However, I still have a problem: How can I adjust the page size for printing? I mean when I select for example a landscape page and that page should be portrait, it will be printed on different pages. I know that it is possible to adjust the width of the page instead of adjusting to a percent from the normal size. But one or many of those documents may include one or more pages.
What I want to be done using this tool, beside its present functionality is to auto adjust that percent of the normal size and to set the print range to be all the used range from all the sheets.
Thanks and sorry for my english.
Have a nice day!
I have an excel missunderstanding. It is about VBA programming and printing size limits.
I have done a little tool in VBA - excel macro, that adjusts the page margins (top, bottom, left, right, header and footer).
It is very useful (at least for me) because the user can select as many files as he wants and this tool will adjusts all the sheets from those documents.
You can insert also header / footer values into the documents.
However, I still have a problem: How can I adjust the page size for printing? I mean when I select for example a landscape page and that page should be portrait, it will be printed on different pages. I know that it is possible to adjust the width of the page instead of adjusting to a percent from the normal size. But one or many of those documents may include one or more pages.
What I want to be done using this tool, beside its present functionality is to auto adjust that percent of the normal size and to set the print range to be all the used range from all the sheets.
Thanks and sorry for my english.
Have a nice day!
