ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Prevent print setup changes (https://www.excelbanter.com/excel-programming/406807-prevent-print-setup-changes.html)

Kelly P[_2_]

Prevent print setup changes
 
Can I prevent users from changing the print scaling? Or is there a script
that can be written to check the scaling and reset it before the sheet is
printed?

Matthew Pfluger

Prevent print setup changes
 
Yes, you can write a macro that alters the Print Setup. I usually do this by
recording a macro of me setting up the print the way I want it.

You can also capture Print events. You could use this to modify page setup
prior to printing or stop the user from printing altogether.

Matthew Pfluger

"Kelly P" wrote:

Can I prevent users from changing the print scaling? Or is there a script
that can be written to check the scaling and reset it before the sheet is
printed?



All times are GMT +1. The time now is 08:17 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com