View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
mr_teacher
 
Posts: n/a
Default 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:(


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