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,

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

<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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,
>