Format workspace on file opening and restore it on closing

[phil_r]

Hi,
I'd like to create a macro that formats the workspace to make it as clean as possible when the file is opened. Then, I'd like to restore the initial workspace when the user closes the file.
How can I create a macro that lounches on file opening?
And another one that lounches when the file is closed?
Or is there another way to obtain that?
Thanks in advance for your help;
Regards
Phil
This message was edited by phil_r on 2002-11-15 07:13

 

[DonkeyOte]

Phil

Naming your Macro AUTO_OPEN will mean it runs when you start the file

Naming another Macro AUTO_CLOSE means it will run when the file is closed.

 

[DonkeyOte]

Sorry Phil forgot the other bit

Name your views - say mine is LUKE

Sub AUTO_OPEN

ActiveWorkbook.CustomViews("LUKE").Show

End Sub


Sub AUTO_CLOSE

ActiveWindow.Zoom = 100

End Sub

Luke

 

[phil_r]

THANKS!!!
That's exactly what I wanted to know.
You've made a happy man.
Ciao and good week end
Phil