Print Problems

[prometheus15]

Hey everyone,

I have created an expense form for my organization. This expense form is very locked down and cannot be altered. The page setup is supposed to be locked down so that the 2 pages are printed identically every time... Our AP girl tells me that she gets the odd expense form that has been submitted that has these two pages all screwed up with half printing on one and the remaining printing on the other... Is this a printer setting that I cannot dictate from the file or what is up??? Any ideas. I would aprreciate ANY help... Thanks very much!

Mike Gaudet

 

[Smitty]

Welcome to the Board!

Unfortunately print settings don't always go with your workbook. You can record a macro doing File-->Page Setup to capture your settings. (Note that you will get ALL of the page setup settings), so it's generally a good idea to pare down what you don't need.

That code can then be put in a Private Sub Worksheet_BeforePrint event to apply the setting before the ws is printed. Note that this is probably one of the longest events that you can invoke, so users may see a bit of lag.

Hope that helps,

Smitty

 

[prometheus15]

Thanks for the advice

I have set up the macro and found all the subs I need to align the page the way I want, but how exactly do you make it so that it runs before print... I have found the before_print thing but how do you connect htis to the class module??? Thanks again

Mike

 

[prometheus15]

Thanks for the advice

I have set up the macro and found all the subs I need to align the page the way I want, but how exactly do you make it so that it runs before print... I have found the before_print thing but how do you connect htis to the class module??? Thanks again

Mike