Re: Help with auto macro on closing

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

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

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:
> View this thread:


In response to

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