Print Preview Ribbon

[Mike S]

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

 

[JLGWhiz]

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

 

[Homey]

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

|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

 

[Mike S]

Thanks. Screen updating fixed it.