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