I will help other people even though no one is here to help me out....I'll try my best to help you out...I can answer only the question that I know!!!1



Corey .... wrote:

Excel 2007 Print Preview
15-Mar-09

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....

Previous Posts In This Thread:

On Sunday, March 15, 2009 7:14 PM
Corey .... wrote:

Excel 2007 Print Preview
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....

On Sunday, March 15, 2009 8:05 PM
OssieMa wrote:

Hi Corey,Is the Print Preview tab visible at the top left.
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:

On Sunday, March 15, 2009 8:24 PM
Corey .... wrote:

No the Tab is NOT Visible!??
No the Tab is NOT Visible!??

On Sunday, March 15, 2009 9:01 PM
OssieMa wrote:

Hi again Corey,If the Print Preview tab is missing then that tends to indicate
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:

On Sunday, March 15, 2009 9:53 PM
Corey .... wrote:

OssieMac,If i use the Micosoft PrintPrintPreview option i get the ribbon to
OssieMac,
If i use the Micosoft PrintPrintPreview option i get the ribbon to display
the Close option etc.
But when running it via code it does not appear.
There is no ribbon displayed.

For now i added a code for the user to Print instead of Preview to get
around the problem.

Corey....
"OssieMac" wrote in message
...

On Sunday, March 15, 2009 10:41 PM
OssieMa wrote:

Hi again Corey,I said I was out of ideas but one more thought now that you
Hi again Corey,

I said I was out of ideas but one more thought now that you have said that
it only occurs with code and thinking back to using Esc to halt the code
makes me think that the code is in an eternal loop due to an event some where.

Try using the following:-

Application.EnableEvents = False
ActiveWindow.SelectedSheets.PrintPreview
Application.EnableEvents = True

If it works then look for other event code. Particulary in the Personal.xlsb.


--
Regards,

OssieMac


Submitted via EggHeadCafe - Software Developer Portal of Choice
Get Started with SQLite and Visual Studio
http://www.eggheadcafe.com/tutorials...-sqlite-a.aspx