Hi again Corey,

If the Print Preview tab is missing then that tends to indicate that the
ribbon is missing entirely. Is that what you mean or do you mean that the
Preview block is missing from the ribbon? If it is the Preview block (or part
of it) then enter the following phrase into help and check it out.

I can't see a command on the Ribbon

If the ribbon is missing then what about the ribbon on the normal worksheet?
Are you able to change ribbons? Are all of the options that should be
available there or are some disabled?

Check that it is a valid and activated copy of xl2007. It is not something I
have ever tested but I have been told that many functions are lost if the
application is not activated.

If none of the above fixes it then I am out of ideas other than to get the
original disk and do a repair/re-install.


--
Regards,

OssieMac


"Corey ...." wrote:

No the Tab is NOT Visible!??



"OssieMac" wrote in message
...
Hi Corey,

Is the Print Preview tab visible at the top left. If so then click it to
maximize the ribbon.

--
Regards,

OssieMac


"Corey ...." wrote:

Am using 2007 and on my PC i have a macro to display a sheet in Print
Preview as: ActiveWindow.SelectedSheets.PrintPreview

When run i get a Red Close Button on the Ribbon.

But on another users PC on our Network there is NO Close Print Preview
Button available, the only was to exit the macro is by hitting ESC.

How can i enable the Close Print Preview Button on the other pc?

Corey....