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

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

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

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