Thanks for the suggestions.

1. I had already disregarded the calendar control because of the
reason given above. We know this does not exist on some users machines
(and it is not a simple task to update)

2. Have been instructed not to use Access (originally designed my
whole program in access with the calendar feature however was told it
HAD to be in Excel by the powers that be (our users are not
compfrtable with Access and no matter how much I explained it was
turned down))

Therefore I am still nowhere. I understand this is an extremly long
winded and complex task, however I have no other options.

FYI - the code is already in the sheet to put in the calendar entries
- we originally trialled this using Outlook (another great idea that
was rejected) so the code to put the entries somewhere is there - I
just need a place to put them.

Some thoughts - putting the entries into the daily view (using code
mentioned above) and using formula to link the entries from the daily
view to the monthly view (eg. =Left etc etc). Any ideas whether this
would work.

As I said there is no requirement for a daily view if I can find a way
to fit all this information comfortably into the weekly view - but so
far I am struggling with this.

Again thanks for your suggestions and help so far.