+ Reply to Thread
Results 1 to 4 of 4

Help with auto macro on closing

  1. #1
    Forum Contributor
    Join Date
    05-11-2006
    Posts
    104

    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

  2. #2
    Don Guillett
    Guest

    Re: Help with auto macro on closing

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

    --
    Don Guillett
    SalesAid Software
    dguillett1@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...o&userid=34352
    > View this thread: http://www.excelforum.com/showthread...hreadid=542503
    >




  3. #3
    Forum Contributor
    Join Date
    05-11-2006
    Posts
    104
    Thank - managed to find that and got the macro working perfectly!

    Thanks for pointing me in the right direction!

  4. #4
    Don Guillett
    Guest

    Re: Help with auto macro on closing

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

    --
    Don Guillett
    SalesAid Software
    dguillett1@austin.rr.com
    "mr_teacher" <mr_teacher.27xuvs_1147847119.4221@excelforum-nospam.com> wrote
    in message news:mr_teacher.27xuvs_1147847119.4221@excelforum-nospam.com...
    >
    > 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
    >




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1