| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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, |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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, |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro & Print Preview? | Excel Discussion (Misc queries) | |||
| Why does macro speed slow after Excel Print or Print Preview? | Excel Programming | |||
| Macro buttons tiled after print / print preview | Excel Programming | |||
| VBA Help - Running a macro when closing print preview | Excel Programming | |||
| Resuming code after closing a print preview | Excel Programming | |||
Linear Mode
