Am trying to have an entry made once a month. Another thought is would need
to be able to change amount of entry. In all my searches I cant seem to
locate a way to do this. It needs to happen once a month. Maybe it needs to
be done from a userform? This could trigger event. (RUN UPDATE) Would need to
reject if all ready done this month. Or could this be done on workbook open
or close. Would like it to to happen without user input if possible. Every
effort I've tried changes when date changes. I did receive code that will
update on first of month. Probably did not explain myself. Program may not
be opened on first.
Any and all input Greatly Appreciated
Thanks

To prevent updates more than once a month you need to have a cell in th
eworkbook when the last update was performed. Then on a workbook open check
if the update was perform in the current month and year (just in case you
don't open the workbook for a year).

"Curt" wrote:

Am trying to have an entry made once a month. Another thought is would need
to be able to change amount of entry. In all my searches I cant seem to
locate a way to do this. It needs to happen once a month. Maybe it needs to
be done from a userform? This could trigger event. (RUN UPDATE) Would need to
reject if all ready done this month. Or could this be done on workbook open
or close. Would like it to to happen without user input if possible. Every
effort I've tried changes when date changes. I did receive code that will
update on first of month. Probably did not explain myself. Program may not
be opened on first.
Any and all input Greatly Appreciated
Thanks