User form linked to Macro to show print preview

[Howardc1001]

I have a user form and one of the items is to show the print Preview for several sheets

when running the macro , I am able to to select "ClosePrint Preview"


However when running the macro via the user form" it freezes and I need to right click on the task bar for the workbook and select close window

It would be appreciated if someone could assist me so that the printview using the user form does not freeze and can select the or cancel button to exit




See User form code below

Please Login or Register  to view this content.

Please Login or Register  to view this content.

See macro below

Please Login or Register  to view this content.

[sintek]

Set Up Userform to Show as non modal

Please Login or Register  to view this content.

[Howardc1001]

Hi Sintek


Many Thanks for the help. Code works perfectly

[sintek]

All good...Tx for rep +