Hi,

I have made my own Print dialog (a modal userform) with a button Preview on
it. Now, I test it out and the userform stays in front of the (background)
printpreview. There is no way to get out of this, unless resetting my
computer. Is there a way to get out of this situation without losing my
code? (I know I had to hide the userform but I forgot!)

Thanks
Jos Vens

Hello Jos,

To hide the from: UserForm1.Hide

Sincerely,
Leith Ross


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465
View this thread: http://www.excelforum.com/showthread...hreadid=507921

Hi Leith,

If you read my question well, I know you have to hide the form, but what if
you didn't? Is the code gone? Can you still get it in any way? eg. you did
not save your code for a couple of hours... is it lost?

Jos


"Leith Ross"
schreef in bericht
...

Hello Jos,

To hide the from: UserForm1.Hide

Sincerely,
Leith Ross


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile:
http://www.excelforum.com/member.php...o&userid=18465
View this thread: http://www.excelforum.com/showthread...hreadid=507921

Can you click the Close box at the upper right on the form? Gets rid
of the form and stops its code.

No, you can't do nothing, neither in excel, nor in vba: everything is
blocked until you close the preview screen, but you can't close it because
the upper form is modal. Even Ctrl-Break does not work, but maybe a
key-combination that I don't know works to get rid of either the preview
window, or the modal form.

Jos

"Mark Lincoln" schreef in bericht
oups.com...
Can you click the Close box at the upper right on the form? Gets rid
of the form and stops its code.

How about Ctrl-Alt-Del to get to the Task List? With luck, you can
close the preview (if its process is listed separately) without closing
Excel.