User form doesn't unload with a print preview in front of it in a code bloc

**mdovey** · 04-27-2014, 08:10 AM

I have a user form that when the save button that is on it is pressed it runs a ton of code. All of this code can be ignore as it is irrelevant to the problem. The only two parts to the code bloc that seem to conflict with each other and I'm not sure why is the unloading of the user form and the calling of a print function. If I call on the print function before unloading the user form the print preview is displayed but the user form is displayed over it and wont disappear and I cant close the user form or use the print preview. If I call on the print function after unloading the user form the print preview is not displayed as if it didn't work (Most likely it didn't even work). Here is my code:

Save code bloc

Please Login or Register  to view this content.

Print Function code

Please Login or Register  to view this content.

**HaHoBe** · 04-27-2014, 08:16 AM

Hi, mdovey,

mabye use

Please Login or Register  to view this content.

And I wonder why you set objects to worksheets and do not rely on these in the further code.

Ciao,
Holger

**mdovey** · 04-27-2014, 08:24 AM

I will try this thank you very much. Ha XD... do not make fun of my code that make no sense I am fairly new to VBA. I did realise after I had done it but couldn't be bothered to correct it so it just stayed as it was but it still does the job so as for now it will do.