+ Reply to Thread
Results 1 to 3 of 3

Sheet Change Question

  1. #1
    Registered User
    Join Date
    02-06-2013
    Location
    Ohio
    MS-Off Ver
    Excel 2016
    Posts
    50

    Sheet Change Question

    Hey guys, I have a user function that I want to recalculate when I switch between sheets. I am already using Application.Volatile, but it still won't recalculate when I focus on a different sheet.

    Any ideas?

  2. #2
    Registered User
    Join Date
    02-06-2013
    Location
    Ohio
    MS-Off Ver
    Excel 2016
    Posts
    50

    Re: Sheet Change Question

    A-ha! Figured it out.

    Private Sub object_SheetActivate(ByVal Sh As Object)
    Calculate
    End Sub

    placed in the ThisWorkbook module

  3. #3
    Registered User
    Join Date
    02-06-2013
    Location
    Ohio
    MS-Off Ver
    Excel 2016
    Posts
    50

    Re: Sheet Change Question

    I would still be interested to learn a bit of code that I can put directly into my User Function that can have the same effect.

+ 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. [SOLVED] Event Change question--trying to make two things happen in the same sheet.
    By Jaron_t in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-07-2012, 04:41 PM
  2. Replies: 6
    Last Post: 11-05-2012, 10:04 AM
  3. Macro to change Pivot Data to new sheet, where sheet name will change
    By sarails in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-10-2010, 12:10 AM
  4. Excel 2007 : Font Change Question
    By dabolay in forum Excel General
    Replies: 3
    Last Post: 04-01-2010, 01:22 PM
  5. % Change Question
    By StephanieJ in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-29-2007, 07:40 PM
  6. Event Change Question
    By pikapika13 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-05-2006, 02:10 PM
  7. [SOLVED] Change workbook sheet reference using cell A1 to change a vairable
    By Reed in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-20-2005, 04:06 PM
  8. color change question
    By Travis in forum Excel General
    Replies: 2
    Last Post: 01-16-2005, 02:06 PM

Tags for this Thread

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