I added a calendar control to a spreadsheet by building a Personal.xls file
and it works finr for me. I have two questions:
1. Is it possible to add an icon to a cell (like the drop down arrow) that
will trigger the calendar?
2. How do I package the spreadsheet so that I can send it to others to use
and they can use the calendar feature?
Thank you for your time,

Hi dpm1028

You can use this for a range
http://www.rondebruin.nl/calendar.htm
Maybe you can give the date cells a different color ?

> 2. How do I package the spreadsheet so that I can send it to others to use
> and they can use the calendar feature?
Always a problem
Build your file in the lowest Excel version and I hope for you that the users have Access installed

More info here
http://www.rondebruin.nl/calendar.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"dpm1028" <(E-Mail Removed)> wrote in message news:4ED13D42-38C0-4DF5-B381-(E-Mail Removed)...
>I added a calendar control to a spreadsheet by building a Personal.xls file
> and it works finr for me. I have two questions:
> 1. Is it possible to add an icon to a cell (like the drop down arrow) that
> will trigger the calendar?
> 2. How do I package the spreadsheet so that I can send it to others to use
> and they can use the calendar feature?
> Thank you for your time,