View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] rabblerowzer@yahoo.com is offline
external usenet poster
 
Posts: 3
Default 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,