+ Reply to Thread
Results 1 to 2 of 2

Exemption List / Timer Macro

  1. #1
    Registered User
    Join Date
    12-05-2023
    Location
    USA
    MS-Off Ver
    MS Office 365
    Posts
    5

    Exemption List / Timer Macro

    Please Login or Register  to view this content.
    Please Login or Register  to view this content.
    Please Login or Register  to view this content.
    I have this macro in my workbook. The first 2 are in "ThisWorkbook", the third one is in a module.It initiates a Timer for 2:30 on workbook open, and if no cells are updated within 2:30, it saves and closes the workbook. If cells have been updated, it resets the timer. I added the ExemptUsers portion not too long ago, but it doesn't work as intended. It works if you just open the workbook, but dont make any changes to it, but if you make changes to any cells, it resets and starts the timer, even if your name is on the ExemptUsers list.

    What am I missing to have it so the user is completely exempt from the timer regardless of cell updates or not?
    Last edited by vettaforza; 03-27-2024 at 07:28 AM.

  2. #2
    Forum Expert
    Join Date
    02-11-2014
    Location
    New York
    MS-Off Ver
    Excel 365 (Windows)
    Posts
    6,124

    Re: Exemption List / Timer Macro

    Remove this line

    Please Login or Register  to view this content.
    And put this at the top of a standard codemodule, just below any Option declarations.

    Please Login or Register  to view this content.
    Then change this line, in the change event, from

    Please Login or Register  to view this content.
    to

    Please Login or Register  to view this content.
    Last edited by Bernie Deitrick; 03-26-2024 at 03:03 PM.
    Bernie Deitrick
    Excel MVP 2000-2010

+ 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. Countdown timer Working BUT starting the timer repeatedly SPEEDS UP TIMER!
    By Vinospam in forum Excel Programming / VBA / Macros
    Replies: 67
    Last Post: 03-30-2019, 06:42 PM
  2. [SOLVED] Need formula for Group Exemption from Theory, Internal & Practical
    By vijubhau in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 01-25-2018, 07:54 PM
  3. [SOLVED] Allow exemption when Prevent Duplicate is Applied
    By jap5lap in forum Excel General
    Replies: 10
    Last Post: 12-22-2014, 08:33 PM
  4. [SOLVED] Filter table for duplicate entries with exemption rule
    By ben_hensel in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-14-2013, 06:48 AM
  5. [SOLVED] Count unique values in a data range with exemption
    By lheyanne in forum Excel Formulas & Functions
    Replies: 18
    Last Post: 03-01-2013, 11:48 AM
  6. Replies: 1
    Last Post: 12-12-2012, 08:46 PM
  7. [SOVED]erasing all worksheets with exemption
    By burugudug in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 07-29-2010, 02:42 AM

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