Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 ?. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
UserForm PrintPreview & Print buttons | Excel Programming | |||
Printpreview problem - disable various buttons | Excel Programming | |||
ActiveX Controls moving upon print/printpreview | Excel Discussion (Misc queries) | |||
How to: Make user click End User License Agreement acceptance | Excel Programming | |||
[how to] VBA catching close/print in printpreview | Excel Programming |