I'd be glad to help, but there's a lot of information missing from
your request, such as

1) Do you want the code to run on demand, or on a real-time basis?
2) Do you want the code to run from Outlook, or from Excel?
3) Where would the person write "Annual Leave", in the body of the
calendar entry, or the subject, or the location?
4) What do you mean by "manipulate"?

You need to be as specific and detailed as possible so that any code
someone provides you will be relevant.

--JP


On Jun 4, 6:02 pm, robzrob wrote:

Hello JP

My Outlook is 2000 (9.0.0.2711)

My Excel is 2000 (9.0.2720)

I'm hoping any solution (yours, I hope!) will allow me to work on it
at home but use it at work, where the version is later - 2003, I
think. Will that be a problem?