Closing Print Preview in Excel Macro
Hi,
I have recorded an Excel Macro that goes into print preview and formats the page in case the user wants to print. However, the macro will not record the "Closing" of the Print Preview. Is there some VBA code I can insert into the macro which will close print preview and take the user into Edit mode instead of Print Preview mode? Thanks, |
Closing Print Preview in Excel Macro
If you need the user to see the output in Print Preview, closing it in code
makes no sense, as you cannot tell when the user is "ready". If you do not need the user to see the output, don't go into Print Preview. NickHK wrote in message oups.com... Hi, I have recorded an Excel Macro that goes into print preview and formats the page in case the user wants to print. However, the macro will not record the "Closing" of the Print Preview. Is there some VBA code I can insert into the macro which will close print preview and take the user into Edit mode instead of Print Preview mode? Thanks, |
All times are GMT +1. The time now is 03:38 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com