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

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop
You must log in or register to reply here.

Similar threads

C
  • Solved
Message box over print preview
2
Replies
14
Views
1K
Jaafar Tribak
Jaafar Tribak
C
  • Question
Formatting issue - Space being inserted above some word wrapped cells with autofit - not the same cells as print preview
Replies
0
Views
844
CBme
C
JohnZ1156
  • Question
Print macro not allowing view of multiple pages in Preview
Replies
0
Views
548
JohnZ1156
JohnZ1156
Ottsel
  • Question
Workbook Crashes on Print Preview - ComboBox & TextBox
Replies
0
Views
375
Ottsel
Ottsel
E
  • Question
Excel moves images in Preview/Print/Print to PDF and Save to PDF
Replies
0
Views
1K
eli_m
E

Forum statistics

Threads
1,216,555
Messages
6,131,374
Members
449,647
Latest member
pbapro2b

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