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?

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" <St. wrote in message
...
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?

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

"St. Louey" wrote:

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?

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" wrote in message
...
I would like it to be the last day of the calendar month.

"St. Louey" wrote:

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?

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.

"Bob Phillips" wrote:

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" wrote in message
...
I would like it to be the last day of the calendar month.

"St. Louey" wrote:

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?