Print Preview Ribbon

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
 
J

JLGWhiz

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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2007 Print Preview 7
PrintPreview problem in 2007 1
Excel VBA - Problem with Closing Print Preview 0
Print problems w/ charts excel 2003/2007 3
Print with sevral different print area's 2
Disabling Ribbon in '07 4
Problem in adding macro to ribbon through Add-in 7
Ribbon Display Options askew?? 6

Top