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?

Reset Macro
 

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?