Print Preview Ribbon

  • Thread starter Thread starter Mike S
  • Start date Start date
M

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
 
Is the other computer running the same version of Excel? Ribbons only
started in xl2007.
 
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
 
Back
Top