LinkBack URL
About LinkBacks
I think code will stop when this window is shown. It is easier to let user press Print or Cancel.
I think code will stop when this window is shown. It is easier to let user press Print or Cancel.
- Please remember to mark threads Solved with Thread Tools link at top of page.
- Please use code tags when posting code: [code]Place your code here[/code]
- Please read Forum Rules
Yes, the code is interrupting and waits to run the rest of the codes when the window close.
But even sendkeys doesn't seem to work at my end with application.ontime timevalue("00:00:05")
I thought to close the workbook by using esc as send key and get the user input via msgbox and based on the user selection (Yes/No) we can continue or exit the code. But it's not working as expected
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
It's a mad thought, because when the code doesn't run while the Print Preview is active, then how the Send Keys will run
There are currently 2 users browsing this thread. (0 members and 2 guests)
Posting Permissions
Register To Reply
Bookmarks