Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 10
Default Print Preview Ribbon

I have a macro that has a line:

ActiveWindow.SelectedSheets.PrintPreview.

It works fine on one computer in that it shows the print preview ribbon. On
another computer, the ribbon does not show.

How can I have it show the Print Preview Ribbon when the line executes.

Thanks

Excel 07 on Windows XP
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,565
Default Print Preview Ribbon

Is the other computer running the same version of Excel? Ribbons only
started in xl2007.


"Mike S" wrote in message
...
I have a macro that has a line:

ActiveWindow.SelectedSheets.PrintPreview.

It works fine on one computer in that it shows the print preview ribbon.
On
another computer, the ribbon does not show.

How can I have it show the Print Preview Ribbon when the line executes.

Thanks

Excel 07 on Windows XP



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 143
Default Print Preview Ribbon

ribbon for print perview now show if screen not on. Make sur screenupdating
is true before do preview.

"Mike S" wrote in message
...
|I have a macro that has a line:
|
| ActiveWindow.SelectedSheets.PrintPreview.
|
| It works fine on one computer in that it shows the print preview ribbon.
On
| another computer, the ribbon does not show.
|
| How can I have it show the Print Preview Ribbon when the line executes.
|
| Thanks
|
| Excel 07 on Windows XP

  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 10
Default Print Preview Ribbon

Thanks. Screen updating fixed it.

"Homey" wrote:

ribbon for print perview now show if screen not on. Make sur screenupdating
is true before do preview.

"Mike S" wrote in message
...
|I have a macro that has a line:
|
| ActiveWindow.SelectedSheets.PrintPreview.
|
| It works fine on one computer in that it shows the print preview ribbon.
On
| another computer, the ribbon does not show.
|
| How can I have it show the Print Preview Ribbon when the line executes.
|
| Thanks
|
| Excel 07 on Windows XP


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
First page of Excel sheerepeats in print layout or print preview philfrotonda Excel Discussion (Misc queries) 1 July 12th 07 09:28 PM
Print and Print Preview Graphic Moving Resizing 2007/2003 Adam Rayburn Excel Discussion (Misc queries) 0 April 4th 07 04:18 PM
print preview v page break preview SamB Excel Discussion (Misc queries) 0 November 16th 06 05:09 PM
cell borders that I create dont show on print preview or print scott3435 Excel Discussion (Misc queries) 2 April 6th 06 02:37 AM
Why does macro speed slow after Excel Print or Print Preview? Larry A[_3_] Excel Programming 6 May 16th 05 11:22 AM


All times are GMT +1. The time now is 04:54 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"