On May 12, 8:43*pm, joeu2004 wrote:
See my modified version at
http://www.box.net/shared/x1r3a1mv03 .

I have uploaded an updated version with some improvements.

Most of the improvements are aesthetic.

But I also corrected a defect that crept in after I tested it.

And I made one design change. See the below.

One final note.... Look for #if statements and read the comments
before them. I made some assumptions that you might want to review
and perhaps change my decision about them.

For example, chkFormulas installs the formulas into I50:I54 of all
worksheets. Originally, I excluded the "Calendar" worksheet. Now, I
modify it as well. My interpretation is that "Calendar" is a prototyp
that is copied and renamed when a new employee is added. To that end,
it might be useful to have the formulas already in I50:I54.

Design change.... That logic has been moved from chkFormulas to
fillFormulas, which can be called from the SheetChanged event macro as
well as chkFormulas. If you do not want to install the formulas into
the "Calendar" worksheet, change the appropriate #if 1 to 0 in
fillFormulas.

I am sure these comments are confusing out of context. Hopefully,
they will make some sense when you download my modified version of the
Excel file and look at the macros.