Embedded calendar VBA code...

Hi all,

I'm basically trying to put a calendar in a sheet, which will NOT pop-up but always stay there. I have managed to do this part..

Second, I need the active cell being equal to the date that I choose on the calendar. I suppose, this part needs a linking between the calendar object and excel sheet through some VBA code, and I can't do that.

Could someone please help me?

I searched all the forums, but my VBA is far poor to modify existing "pop-up calendar" codes..

Thanks,
-levent

Right-click on the sheet tab, select View Code, and paste this in the window that opens:

Please Login or Register  to view this content.

that works, great thanks...