Help with auto macro on closing

[mr_teacher]

Hi,

I am sure that this is something dead easy but can't work out where to
put it!!!!

I have used a macro to automatically run when a workbook opens - is it
possible to have a macro that will run on closing?

Basically I have hidden some of the formatting bars when the programme
is turned on and I would like them to become visible again when I
switch it off - but help on how to set the macro off would be ideal

Thanks for the help

Carl

 

[Don Guillett]

have a look in the ThisWorkbook module where your workbook_open event is
stored.

 

[mr_teacher]

Thank - managed to find that and got the macro working perfectly!

Thanks for pointing me in the right direction!

 

[Don Guillett]

glad to help. Better to learn to fish than be given fish.