I'm more interested in print area settings.
I've forgotten what it was called in older versions and these new stupid versions with ribbon don't help finding out.
I think it's called page breaks?
I want to be able to set the page breaks and then have it so that noone can change it afterwards. Is there a macro for it?
If there is a fix to stop all page sets up type functions, I'll settle for that
Do you want to control the print area? If so add the following to the "thisWorkbook" module:where the print area should be whatever area you want it to be.
Please Login or Register to view this content.
If you're happy with someone's help, click that little star at the bottom left of their post to give them Reps.
---Keep on Coding in the Free World---
That's fine if the situation is setting print area..
Let me try explain it better.
I set the print area, one worksheet prints 3 pages, each page a different amount of rows.
My problem arises mainly because I set the print for A3, this worksheet should only ever be printed in A3 and how I've set it out. Someone, and noone is willing to be honest it's them, keeps trying to print it out in A4 and it messes everything up, worse still they save it so the next time someone tries to print it, it prints on 6 A4 pages rather than 3 A3's.
It may be best if you upload a workbook.
As I see it, Mordred's point in post #3 is to let users change the print settings all they want to. But everytime that Print is called, reset the settings to what you want.
It doesn't disable the users ability to change things, just makes the changes irrelevant.
The advantage of that approach is that it is a Workbook specific approach.
On the other hand, disabling capabilites usually effects the whole application and restricting it to your particular workbook is problematic.
_
...How to Cross-post politely...
..Wrap code by selecting the code and clicking the # or read this. Thank you.
Thanks, but I want solutions, not problems, lol
Do you want to print out all worksheets and their A3 ranges? If you do, I'm not quite sure how to do that but if it is a particular sheet you want printed than set the Ws to the sheet name and the printed area to A3. It seems odd that you would want to only print a cell though, is that correct?Originally Posted by Djarn
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks