software

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

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

quot;Pastel Hughesquot; wrote:

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