Steve
See Ron de Bruin's site for use of the calendar control.
http://www.rondebruin.nl/calendar.htm
Gord Dibben MS Excel MVP
>Hi
>
[quoted text clipped - 5 lines]
>TIA
>Steve
Steve - 23 Oct 2007 19:31 GMT
Thanks for the reply
I've just been through the tutorial and found it really interesting as
I've never done anything in VBA before.
I got a bit stuck towards the end as I was trying to add the Custom
Menu Item to my toolbar that appears when I right click on the
spreadsheet
Holding and dragging the custom menu doesn't let me right click on the
screen to open the toolbar that I want
I have no problems adding it to the toolbars at the top of the screen,
but I would find it easier if I could right click on the screen and
select it from there. On the calendar that can be downloaded from the
website it's available with the right click toolbar
Any suggestions how I can do it
TIA
Steve
> Steve
>
[quoted text clipped - 15 lines]
>
> - Show quoted text -
Have a look at data Validation
You need a list of values (dates in your case) elsewhere on the same sheet
best wishes

Signature
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email
> Hi
>
[quoted text clipped - 5 lines]
> TIA
> Steve