View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Matthew Pfluger Matthew Pfluger is offline
external usenet poster
 
Posts: 130
Default 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?