Reset Macro

I have a form which others use which contains a macro that adjusts the form
to fit their screen regardless of the resolution they are using. Is there a
way of automatically setting Excel back to the original zoom ratio, once the
file is closed?

You could insert some code in

Private Sub Workbook_BeforeClose(Cancel As Boolean)
On Error Resume Next

etc to restore the settings that you consider to be the default.

HTH

------------------

"Pastel Hughes" wrote:

> I have a form which others use which contains a macro that adjusts the form
> to fit their screen regardless of the resolution they are using. Is there a
> way of automatically setting Excel back to the original zoom ratio, once the
> file is closed?