+ Reply to Thread
Results 1 to 3 of 3

Making this macro run when I switch to the active tab

  1. #1
    Registered User
    Join Date
    07-14-2014
    Location
    nyc
    MS-Off Ver
    2003
    Posts
    74

    Making this macro run when I switch to the active tab

    Hello

    I'm trying to make this macro run automatically whenever I click into this tab on the workbook. Right now I have it attached to a button that I have to click to make it run, but I would like to have it run automatically.

    Please Login or Register  to view this content.
    Thank you

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Making this macro run when I switch to the active tab

    Put the code in the Activate of the worksheet.
    Please Login or Register  to view this content.
    If posting code please use code tags, see here.

  3. #3
    Registered User
    Join Date
    07-14-2014
    Location
    nyc
    MS-Off Ver
    2003
    Posts
    74

    Re: Making this macro run when I switch to the active tab

    Thank you!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. making formating active?
    By beng404 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-06-2013, 04:46 PM
  2. [SOLVED] Making a cell active.
    By Pierre11 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 07-09-2013, 03:17 PM
  3. Cannot switch to an active excel workbook from word
    By kalt in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-11-2011, 11:44 AM
  4. Making a field active
    By wait3264 in forum Excel General
    Replies: 3
    Last Post: 07-31-2006, 12:03 PM
  5. [SOLVED] How do I switch between windows in the active workbook inside a M.
    By kdreyer in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-04-2005, 06:07 PM

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