Hi, I have created a userform with macros that performs print formatting. I need the userform to maintain control instead of becoming inactive until you return to the home screen. So I want to be in the print preview and I have a button on my form that sets letter size and another that sets legal size paper, I want to switch between the two modes and see the change right away.

Can this be done and if so how?