Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Print Setup | Excel Discussion (Misc queries) | |||
Print Range Setup | Setting up and Configuration of Excel | |||
Copy of Print Setup | Setting up and Configuration of Excel | |||
VBA print setup | Excel Programming | |||
Print Setup | Excel Programming |