Page Breaks changes depending on different computers
Hello guys,
Disclaimer: I hope I have set this up properly for a good post, but this is my first time posting in this sub.
Issue: Prevent Page Breaks from changing position depending on different computers.
My Workbook: I have to write professional reports for my department's Student Society that outline our finances and other aspects of management. This includes multiple worksheets that are being written to or being edited directly by my VBA code. It runs perfectly without any issues apart from the fact that if I use it on a different computer than my own, there is a chance that the page break locations are different thus leading to either an extra page being written or part of the pre-made sentences being cut off in the middle and split to 2 printed pages.
What I have done: As of right now, I have Google'd the issue for similar problems, searched in reddit, referred to my Excel book, and contacted Microsoft Support.
What I've learned about the issue so far: Googling the issue leads to no solution except avoiding the issue. The issue stems from PC Resolution and PC Printer Drivers which I will admit, I have no experience in that aspect of Excel programming.
What I want to ask the knowledgeable people in this subreddit: Is there a way to force Excel to make the Page Breaks in constant positions regardless of the PC, PC resolution, and PC printer drivers.
Thanks a lot everyone!
I really want to thank everyone here in this sub because I have read multiple threads in this sub that have helped me learn a deeper understanding of Excel and VBA. It's a priceless source of information!
Posted Aug 29, 2016, 11:50 PM UTC