EXCEL Print Preview not on top

W

wdriver4

New Member
Joined
Sep 10, 2015
Messages
1
I use VB to Excel Macros to generate reports. The application can print to a PDF File or display the report in Excel Print Preview. When displaying the report in Excel the VB application remains in the foreground. The Excel Print Preview is called from a macro. The application waits for the print preview to be closed before the application continues.

ActiveSheet.PrintPreview
ActiveSheet.Activate


How can I get the print preview to be on top?
 

Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"
You must log in or register to reply here.

Similar threads

B
  • Question Question
Excel hyperlink formula is not clickable when the workbook is converted to pdf
Replies
2
Views
276
bhaskarsharma03
B
C
  • Solved
Message box over print preview
2
Replies
14
Views
2K
Jaafar Tribak
Jaafar Tribak
C
  • Question Question
Formatting issue - Space being inserted above some word wrapped cells with autofit - not the same cells as print preview
Replies
0
Views
1K
CBme
C
JohnZ1156
  • Question Question
Print macro not allowing view of multiple pages in Preview
Replies
0
Views
610
JohnZ1156
JohnZ1156
W
  • Question Question
Clearing ghost images
Replies
1
Views
303
WhoCanDo
W

Forum statistics

Threads
1,223,237
Messages
6,170,924
Members
452,366
Latest member
TePunaBloke

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top