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? |
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