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 ?.

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 ?.

Thanks Tom for this quick answer.
But then I do not need to hide the form before ?

"Tom Ogilvy" wrote:

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 ?.

when a form is modal, it doesn't allow you to select anywhere else until the
form is dismissed. when it isn't modal, it is like any other window. So no,
you should not need to hide it if you show it as modeless.

--
Regards,
Tom Ogilvy



"François" wrote:

Thanks Tom for this quick answer.
But then I do not need to hide the form before ?

"Tom Ogilvy" wrote:

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 ?.

Tom,
Still I need to hide it cause it's a too large window.
so it's OK to hide it with frm.hide , but to redisplay it (and continue the
code ...) I would like to avoid to use .show ... and I do not find a unhide.
I have tried with frmCreche.Visible = True or False but this is not allowed.

Any idea would be better than welcome to help me.

Thanks.

"Tom Ogilvy" wrote:

when a form is modal, it doesn't allow you to select anywhere else until the
form is dismissed. when it isn't modal, it is like any other window. So no,
you should not need to hide it if you show it as modeless.

--
Regards,
Tom Ogilvy



"François" wrote:

Thanks Tom for this quick answer.
But then I do not need to hide the form before ?

"Tom Ogilvy" wrote:

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 ?.

I don't understand your concern with using show. That is the only command
that will show the form again.

Your response about the form being too big is a little surprising since your
original question was:
Is it a way to handle this without having to hide the form ?.

--
Regards,
Tom Ogilvy

"François" wrote in message
...
Tom,
Still I need to hide it cause it's a too large window.
so it's OK to hide it with frm.hide , but to redisplay it (and continue
the
code ...) I would like to avoid to use .show ... and I do not find a
unhide.
I have tried with frmCreche.Visible = True or False but this is not
allowed.

Any idea would be better than welcome to help me.

Thanks.

"Tom Ogilvy" wrote:

when a form is modal, it doesn't allow you to select anywhere else until
the
form is dismissed. when it isn't modal, it is like any other window.
So no,
you should not need to hide it if you show it as modeless.

--
Regards,
Tom Ogilvy



"François" wrote:

Thanks Tom for this quick answer.
But then I do not need to hide the form before ?

"Tom Ogilvy" wrote:

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 ?.