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?
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?
文章標籤
全站熱搜
