Hello, I'm hoping that someone can help if possible please.
I have created a tracker for tasks performed across our department. Each month has 5 rows (but this can increase depending on how many tasks come in) and the days are listed across in the columns.
Each year, we have to re-set the following;
Offset each month so that the first day falls correctly(1-31)
Reformat the colours (blue for weekends, white weekends, black for non days)
It is a bit of a pain having to re-set this every year, especially when you discover that you have set one day incorrectly which has thrown out the whole calendar and I was wondering if there was a way to do this through VBA,
I have put an example below.
<colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>Thank you in advance
I have created a tracker for tasks performed across our department. Each month has 5 rows (but this can increase depending on how many tasks come in) and the days are listed across in the columns.
Each year, we have to re-set the following;
Offset each month so that the first day falls correctly(1-31)
Reformat the colours (blue for weekends, white weekends, black for non days)
It is a bit of a pain having to re-set this every year, especially when you discover that you have set one day incorrectly which has thrown out the whole calendar and I was wondering if there was a way to do this through VBA,
I have put an example below.
<colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody> </tbody> |
<colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>