Preview function

[mqdias]

Hi, another question....

I've inserted a button that makes the same thing as the preview button in excel. But, one of the userform stays in front and blocks the access to the preview page.

How can i minimize the userforms while the preview page is shown?


Thanks

[dominicb]

Good evening mqdias

Caution advised here as in my experience the print preview window and userforms don't mix well - macros appear to lose complete control when the window opens.

As a rule, you can't usually minimize userforms, however you can use API's to force a minimize control to appear, but using API's can destabilise an app anyway, so extra, extra caution is advised. If you want to see how to introduce a minimize button to your userform, have a look at Stephen Bullen's FormFun workbook here :

http://www.bmsltd.ie/Excel/SBXLPage.asp

All in all, probably not what you wanted to hear ...

HTH

DominicB

[mqdias]

It was just that what happened to me. It blocked everything and i was needed to force the excel to close.

Thank you anyway.

Do you know any tutorial where i can find instruction how to make my own report sheet with the final calculated values, in visual basic?

[royUK]

Simply hide the UserForm before the PrintPreview

[mqdias]

Hi!

Thank you very much for the answers.
Roy, that worked very well, but how can i show again my userform after i click the "close" button in the print preview?

Thank you so much!!

[royUK]

You would need to have a button or macro to display the form, you probably have this already.

[mqdias]

So, there is no code that can detect the moment i click the "close button" in the print preview....

[royUK]

So, there is no code that can detect the moment i click the "close button" in the print preview....

I can't think of any, there is no After_Print event

[royUK]

Edit: amended code slightly.

Just tried this usint the OnTime method

In the Before_Print:

Please Login or Register  to view this content.

Then in a general module:

Please Login or Register  to view this content.

When you close the PrintPrview the form will show.

[mqdias]

Hi,

Thank you for the help, but i didn't understand quite well your answer. I have the following code. How can i insert the code sugested by you?

Please Login or Register  to view this content.

[royUK]

The code in the Before_Print events sets the ontime method to run the showForm macro after two seconds. This is interrupted by the PrintPreview, but when you close the Preview Window the code restarts and the form is shown. By setting the time to two seconds there is no delay.

I'm not sure why you want two forms displayed, but simply amend the showForm code to load both.

[mqdias]

Hi again. Thank you once more for your kindly attention!

I'm running the code well, as you told me. I've only have a problem related to the 2 UserForms. 1 is fo inserting data and the other presents the results. So, i must have both a the same time, wich i have by puting in UserForm1_Initialize() -> Userform2.show vbModeless

In this case, after the print preview, this code doesn't work and the UserForm2, is showed only after UserForm1 is closed.

How can i put both of the UserForms working at the same time?

Thanks

[royUK]

I wouldn't use two userforms, but only have one with a MultiPage control on it. Much easier to work with.