closing Print Preview mode

C

chander

New Member
Joined
Dec 2, 2002
Messages
19
hi .. its some wat related to my old question .. can one tell how i can close the print preview mode through code .. i meant when workbook is in print preview mode i want to come back in normal mode by running my code .. not by click on Close Button . there is Window property to get in normal mode but that works when u r in PageBreak preview mode .. not in print preview mode.. i want to get to normal view from Print previewview mode in my program.
 

Excel Facts

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).
Sort by date Sort by votes
Preview Mode

I believe that once you enter Preview Mode, Excel is waiting for an answer and won't give up control until it gets one.
Is there some other way to accomplish whatever it is that you are using print preview for? Since you don't want to have the user click "close".

Jaamie
 
Upvote 0
You must log in or register to reply here.

Similar threads

Y
  • Solved
Greyed Rows - print BLACK
Replies
3
Views
390
rollis13
rollis13
J
  • Question
Print Preview disorders pictures
Replies
0
Views
267
Johnssen
J
W
  • Question
a backup nightmare (may cause depression)
Replies
6
Views
439
johnnyL
J
C
  • Question
Why is Excel only display one cell in normal view?
Replies
5
Views
4K
rollis13
rollis13
B
  • Question
Populate Worksheet Listbox with Worksheet Names based on Cell Value then select to print as one document
Replies
1
Views
606
DanteAmor
DanteAmor

Forum statistics

Threads
1,214,918
Messages
6,122,252
Members
449,075
Latest member
staticfluids

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