"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
See how Ron de Bruin does it.

http://www.rondebruin.nl/calendar.htm

Note the "more information" link to download mscal.ocx if needed.


Gord Dibben MS Excel MVP

On Thu, 26 Jul 2007 18:08:14 GMT, "Banzai" wrote:

I have a macro that runs a pop-up calendar and applies the date selected
from within the calendar to the currently selected cell.

As default I have to run this manually via tools macromacrosrun.

My question is, how do I force this so that as soon as the user clicks on
the cell that particular macro (OpenCalendar) is run and the calendar is
opened for populating the cell that has just been clicked.

If possible i'd also like to limit any user entry for certain cells other
than that populated by the calendar macro.

Thanks in advance



Seen that, but I don't (think) it answers my question