View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default Distributing spreadsheets with VBA code

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" wrote in message ...
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,