|
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.... |
Excel 2007 Print Preview
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.... |
Excel 2007 Print Preview
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.... |
Excel 2007 Print Preview
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.... |
Excel 2007 Print Preview
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 ... 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.... |
Excel 2007 Print Preview
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
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 |
ICT/IT
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: 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 On Sunday, March 21, 2010 4:29 PM ann thomas wrote: 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/tutorials...ipeline-f.aspx |
| All times are GMT +1. The time now is 12:02 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com