+ Reply to Thread
Results 1 to 3 of 3

run the macro automatically after opening the file

  1. #1
    Forum Contributor
    Join Date
    12-15-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    672

    run the macro automatically after opening the file

    Dear friends,
    I have recorded a macro for my database and I want to run it automatically after opening the workbook. I also want to display a message after completing the macro 'Welcome' so that I could understand that the macro is finished.
    Please see the word file with a code. Please do the necessary changes in the code and send it to me at the earliest.
    Thanking you in anticipation.

    Mukesh
    Attached Files Attached Files

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,770

    Re: run the macro automatically after opening the file

    I have slightly adjusted your recorded macro and copy and paste it in a module.

    Please Login or Register  to view this content.
    Copy the below code and paste it in THISWORKBOOK code window

    Please Login or Register  to view this content.


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  3. #3
    Forum Contributor
    Join Date
    12-15-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    672

    Re: run the macro automatically after opening the file

    Hello friend,
    Excellent! It's working fine and fulfill my requirements.
    Thank you once again.

    Mukesh

+ 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