Re: Help with auto macro on closing

Giganews Newsgroups
Subject: Re: Help with auto macro on closing
Posted by:  Don Guillett (dguillet…@austin.rr.com)
Date: Tue, 16 May 2006

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

--
Don Guillett
SalesAid Software
dguillet…@austin.rr.com
"mr_teacher" <mr_teacher.27wlyy_1147788904.4652@excelforum-nospam.com> wrote
in message news:mr_teacher.27wlyy_1147788904.4652@excelforum-nospam.com...
>
> 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?action=getinfo&userid=34352
> View this thread:http://www.excelforum.com/showthread.php?threadid=542503

Replies

In response to

Help with auto macro on closing posted by mr_teacher on Tue, 16 May 2006