| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Restarting a macro | Excel Worksheet Functions | |||
| Closing File Error | Excel Discussion (Misc queries) | |||
| macro with F9 | Excel Discussion (Misc queries) | |||
| Make Alignment options under format cells available as shortcut | Excel Discussion (Misc queries) | |||
| Playing a macro from another workbook | Excel Discussion (Misc queries) | |||
Linear Mode
