software

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: www.excelforum.com/member.php...oamp;userid=34352
View this thread: www.excelforum.com/showthread...hreadid=542503have a look in the ThisWorkbook module where your workbook_open event is
stored.

--
Don Guillett
SalesAid Software

quot;mr_teacherquot; gt; wrote
in message ...
gt;
gt; Hi,
gt;
gt; I am sure that this is something dead easy but can't work out where to
gt; put it!!!!
gt;
gt; I have used a macro to automatically run when a workbook opens - is it
gt; possible to have a macro that will run on closing?
gt;
gt; Basically I have hidden some of the formatting bars when the programme
gt; is turned on and I would like them to become visible again when I
gt; switch it off - but help on how to set the macro off would be ideal
gt;
gt; Thanks for the help
gt;
gt; Carl
gt;
gt;
gt; --
gt; mr_teacher
gt; ------------------------------------------------------------------------
gt; mr_teacher's Profile:
gt; www.excelforum.com/member.php...oamp;userid=34352
gt; View this thread: www.excelforum.com/showthread...hreadid=542503
gt;

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: www.excelforum.com/member.php...oamp;userid=34352
View this thread: www.excelforum.com/showthread...hreadid=542503glad to help. Better to learn to fish than be given fish.

--
Don Guillett
SalesAid Software

quot;mr_teacherquot; gt; wrote
in message ...
gt;
gt; Thank - managed to find that and got the macro working perfectly!
gt;
gt; Thanks for pointing me in the right direction!
gt;
gt;
gt; --
gt; mr_teacher
gt; ------------------------------------------------------------------------
gt; mr_teacher's Profile:
gt; www.excelforum.com/member.php...oamp;userid=34352
gt; View this thread: www.excelforum.com/showthread...hreadid=542503
gt;