User Form properties

[scouse13]

Hi guys, below i have code for printing a userform, it all works in as far as it prints landscape etc, the only problem being it does not print the whole screen, after playing about with it for hours, i have just noticed there is a zproperty for the userform called zoom, when i changed this to 80% and then printed the userform this works fine and the whole form prints.

My question is, within my code can any code be added that can change the zoom property value to 80, and then change it back too 100 once the form has printed, i dont want a user going into the code or property windows changing it manually.

Please Login or Register  to view this content.

any help greatly appreciated

scouse13

[CK76]

Where in the module is your code triggered?

Code syntax will change based on where it's located.

Assuming that it's somewhere within UserForm (i.e. command button etc).
Before you run above code.

Please Login or Register  to view this content.

Then set back to 100 after your code.

[Arkadi]

To elaborate (while completely agreeing with CK76), you should only need the zoom setting during the snapshot, so :

Please Login or Register  to view this content.