Help with auto macro on closing

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

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

--
Don Guillett
SalesAid Software
[email protected]
"mr_teacher" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>
>
> --
> mr_teacher
> ------------------------------------------------------------------------
> mr_teacher's Profile:
> http://www.excelforum.com/member.php...o&userid=34352
> View this thread: http://www.excelforum.com/showthread...hreadid=542503
>

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

Thanks for pointing me in the right direction!

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

--
Don Guillett
SalesAid Software
[email protected]
"mr_teacher" <[email protected]> wrote
in message news:[email protected]...
>
> Thank - managed to find that and got the macro working perfectly!
>
> Thanks for pointing me in the right direction!
>
>
> --
> mr_teacher
> ------------------------------------------------------------------------
> mr_teacher's Profile:
> http://www.excelforum.com/member.php...o&userid=34352
> View this thread: http://www.excelforum.com/showthread...hreadid=542503
>