If you are using xl2000 or later, show the form as modeless when you show it
before this code

frmCreche.show vbModeless

--
Regards,
Tom Ogilvy


"François" wrote:

I have this
Application.EnableEvents = False
frmCreche.Hide ' this is mandatory otherwise problem to print preview
Application.Dialogs(xlDialogPrint).Show
frmCreche.Show
Application.EnableEvents = True

The problem is that I have to hide the userform in order to be able to
manage the a printpreview. Cause in that case, the userform is still
displayed and it's impossible to access the controls of the print preview.
Is it a way to handle this without having to hide the form ?.