Hello,
I'm making a special calendar for work. We are a team of 9 persons. We don't
work all at the same time, because we have to work 7 days (day and night).
The layout of the different sheets is done. Even the formulas in the
different sheets.
I've found a module for calculating the specific hollidays.
Now I'm trying to automatisate the different worksheets.
On each sheet I would like to have the hollidays in colors. Also I would
like to have the different workingdays of each person in different colors. On
opening the workbook, this works fine.
Now I want to fill in for each person (on a row below the workingperiod)
when they are absent for some reason. That cell must change to a specified
color. The value of that cell comes in the row above by a formula. Now that
cell must get the same color of the cell below.
Also, the value AND the color must change on a worksheet for that specified
month.
Ex:
Januari
A B C D
1 2 3 4 <-- days of that month
XXX 3 3 <-- row with formulas -- must get the new value
p01 <-- row to fill in certain values -- p01
must become P01

On sheet "Januari", the value of day 4 must change to "P01", and also the
color must change.
Anyone have an idea how to do this? And where do I have to put the code in?
In a module, in "Worksheet_change", in "Worksheet_calculate"?
Thanks