G
Gord Dibben
I tested the code using Excel 2003 after Insert>Object>Calendar Control 11.0
Works fine for me.
Will trigger only when you select A1 and go away when you select any other
cell.
Maybe you are still in Design Mode?
When you xelect the Calendar can you move it or resize it?
Open the Control Toolbox and hit the "design mode" icon once to exit from
that mode.
Gord
Works fine for me.
Will trigger only when you select A1 and go away when you select any other
cell.
Maybe you are still in Design Mode?
When you xelect the Calendar can you move it or resize it?
Open the Control Toolbox and hit the "design mode" icon once to exit from
that mode.
Gord
I am using excel2003 and the instuction says that by simply selecting from
the active worksheet excel menu "Object" and further select "Calendar" it
will place the calendar on the sheet. It is like the VB code given only works
for excel 2007. Am I right pls?
Dolpan
Gord said:Did you first insert the calendar activex form from the control toolbox>more
controls on your sheet?
Do you have MS Access installed..................you won't have the needed
mscal.ocx file if you haven't.
See Ron de Bruin's site for details and instructions.
http://www.rondebruin.nl/calendar.htm
Gord
[quoted text clipped - 51 lines]Hi Gord,Dolpandotcom
06/16/09