Jim Thomlinson wrote:
For security changes to take effect you need to shut excel doown and re-open
it. If the employee chose disable macros then you just need to shut that
spreadsheet down and reopen it then choos enable when asked...

------------------

Jim answered the question you asked.

On a slightly different subject, why do you need to edit the VBA every day to
change a date setting? Can't you just put the date you want in a known
spreadsheet cell, and have the VBA macro grab that particular date automatically?

Bill