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" <[email protected]> wrote in message
news:[email protected]...
> 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 ?.
Yes you are correct the reason not to hide the form was the problem with the
..show (without modeless).
So There is not problem to have 2 times the .show(modeless) one on loading
the the other after (.hide , printdialog) ?
Thanks.
"Tom Ogilvy" wrote:
> 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" <[email protected]> wrote in message
> news:[email protected]...
> > 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 ?.
>
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks