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?

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.