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

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

--
Don Guillett
SalesAid Software

"mr_teacher" wrote
in message ...

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!


--
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

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

--
Don Guillett
SalesAid Software

"mr_teacher" wrote
in message ...

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