Excel 2007 Print Preview

C

Corey ....

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

OssieMac

Hi Corey,

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

OssieMac

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

Corey ....

OssieMac,
If i use the Micosoft Print>PrintPreview 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....
 
O

OssieMac

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

ann thomas

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

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:

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

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

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 t
maximize the ribbon

-
Regards

OssieMa

:

. wrote:

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

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 Ribbo

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

OssieMa

:

. wrote:

OssieMac,If i use the Micosoft Print>PrintPreview option i get the ribbon to
OssieMac
If i use the Micosoft Print>PrintPreview 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...

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 = Fals
ActiveWindow.SelectedSheets.PrintPrevie
Application.EnableEvents = Tru

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/tutorial...b-b6f46d4f2c6a/get-started-with-sqlite-a.aspx
 
A

ann thomas

I will help you out people!!!



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:

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

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


:

. wrote:

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

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


:

. wrote:

OssieMac,If i use the Micosoft Print>PrintPreview option i get the ribbon to
OssieMac,
If i use the Micosoft Print>PrintPreview 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....

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

ICT/IT
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


Submitted via EggHeadCafe - Software Developer Portal of Choice
BizTalk Custom Pipeline for Splitting Messages
http://www.eggheadcafe.com/tutorial...6-241d5e325f42/biztalk-custom-pipeline-f.aspx
 

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

Top