Calendars

I am looking at inserting a calendar within my spreadsheet. Nonetheless, I
want the calendar to pop up WHEN I click within any cells within the range
H6:H900.

I have looked at sites such as http://www.fontstuff.com/vba/vbatut07.htm and
am ok with setting up the calendar. Nonetheless, how do I set it up so that
the calendar automatically pops up when I click in any cell within the range
H6:H900?

Thanks

Worzel

See Ron de Bruin's site for code.

Adjust the range to H6:H900

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




On Mon, 16 Jan 2006 17:00:35 GMT, "Worzel Gummidge" <scrivomc@hotmail.com>
wrote:

>I am looking at inserting a calendar within my spreadsheet. Nonetheless, I
>want the calendar to pop up WHEN I click within any cells within the range
>H6:H900.
>
>I have looked at sites such as http://www.fontstuff.com/vba/vbatut07.htm and
>am ok with setting up the calendar. Nonetheless, how do I set it up so that
>the calendar automatically pops up when I click in any cell within the range
>H6:H900?
>
>Thanks
>

Gord Dibben MS Excel MVP