View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Homey Homey is offline
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