Microsoft Prompting

[St. Louey]

Every month, one of my employees forgets to change a date on a worksheet. Is
there anyway to add a reminder that pops up when closing the worksheet?

 

[Bob Phillips]

What is the criteria for changing? What should it be changed to?

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[St. Louey]

I would like it to be the last day of the calendar month.

 

[Bob Phillips]

But what triggers that change? You have to have something to fire the code.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[St. Louey]

The date must be changed manually. Sorry, I am not an advanced user, I am
working on it.

I would like to be able to have a reminder each time the user attempts to
close, similiar to trying to close w/o saving, just to make sure some of the
simple reconciliation updates are there.

These recons are done monthly.