Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Distributing spreadsheets with VBA code
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, |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Best method of distributing code | Excel Discussion (Misc queries) | |||
multithreading / distributing excel code | Excel Programming | |||
Distributing Excel Spreadsheets | Excel Discussion (Misc queries) | |||
distributing xl with vba code - how to know what's needed | Excel Programming | |||
Distributing code | Excel Programming |