show sheet when it appears the print dialog box

Hello,
the attached macro works.
After clicking "PRINT MODULE" the print preview is displayed and so far it is OK.
I choose close and it's ok, if you choose print "disappears" the sheet to appear the dialog box of the print.
I choose print and then "reappears" the sheet.
Is it possible when I choose print in the preview to not "disappear" the sheet?
I hope I have explained myself.

Please Login or Register  to view this content.

max_max

I think that the hiding of the preview pane is a built in feature of Windows. To change that, you would need advanced programming to get into the source code of the application.

Hello max_max,

You may receive much more responses if you at least give some feedback on suggested solutions to your Threads, like this Link, for instance.

Regards.

Ciao max_max,

You have been a member for way too long with way too many posts to post a thread with an extremely lacking thread title. Please correct before we can move on. Grazie!

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

@max_max, your English is good enough. The problem I am having is understanding where you want to see the sheet displayed. When I use code to print a sheet and have the Print Preview property on, it displays the active sheet in the preview pane until I click print. It then closes the Print Preview pane because I have excuted the print process. My active sheet automatically returns to the screen. This is the normal process for printing in Excel. So, what part of this process is not working for you?

Originally Posted by max_max

Hi JLGWhiz
The preview is displayed with the macro
I click on the print button in the preview and display the print dialog box but not the sheet
Click on the print button of the print dialog box to print the sheet and close the print dialog box
The sheet reappears now.
What I ask is that the sheet is always visible here even with the print dialog box activated.
I hope I explained myself.
max_max

It should display an image of the the page from the sheet that it will print in the preview dialog box. If it does that for you then that is normal.
The preview screen uses the entire pane when it appears and I could not get it to diminish so that the active sheet would be displayed at the same time. So apparently the print procedure blocks access to the souce data until the user decides whether or not to print. Once the user dicides which to do, the active sheet will then re-appear. Does this help?

Originally Posted by max_max

The printing procedure is like this, but I thought with the VBA to view the sheet even with the print dialog box activated.
max_max

Not without getting into the application source code and even then it would probably change it for all of Windows, since the printer interface is a Windows application and not just Excel. Sorry, that is outside my expertise.
Regards, JLG