If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#21
|
|||
|
|||
General Excel question
I tested the code using Excel 2003 after InsertObjectCalendar 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 On Sun, 21 Jun 2009 17:24:31 GMT, "dolpandotcom via OfficeKB.com" u52610@uwe wrote: 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 Dibben wrote: Did you first insert the calendar activex form from the control toolboxmore 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 Hi Gord, [quoted text clipped - 51 lines] Dolpandotcom 06/16/09 |
#22
|
|||
|
|||
General Excel question
I was out of design mode.
I equally selected Calendar Control 9.0. I do not have Calendar 11.o as you did . I was able to resize and also being able to move it from point to the other within the sheet.. I placed my cursor in cell A1 before selecting the Insertobjectcalendar control 9.0. Even after this, if i place my cursor in a different cell, the calendar does not disappear. I need further explanation on what i must have done wrong in mine pls. Hanging by for your response pls. Thanks. Dolpan Gord Dibben wrote: I tested the code using Excel 2003 after InsertObjectCalendar 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 I am using excel2003 and the instuction says that by simply selecting from the active worksheet excel menu "Object" and further select "Calendar" it [quoted text clipped - 20 lines] Dolpandotcom 06/16/09 -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200906/1 |
#23
|
|||
|
|||
General Excel question
It is now showing calendar control 11.0 instead of 9.0. Even with that, it
does no disappear when you click a new cell different from the cell where the calendar is inserted. Advice pls. Thanks. Dolpan Gord Dibben wrote: I tested the code using Excel 2003 after InsertObjectCalendar 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 I am using excel2003 and the instuction says that by simply selecting from the active worksheet excel menu "Object" and further select "Calendar" it [quoted text clipped - 20 lines] Dolpandotcom 06/16/09 -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200906/1 |
#24
|
|||
|
|||
General Excel question
email me and I'll send you a workbook with the Calendar Control in working
condition. Or send me the workbook may be better. gorddibbATshawDOTca Change AT and DOT Gord On Mon, 22 Jun 2009 18:32:46 GMT, "dolpandotcom via OfficeKB.com" u52610@uwe wrote: It is now showing calendar control 11.0 instead of 9.0. Even with that, it does no disappear when you click a new cell different from the cell where the calendar is inserted. Advice pls. Thanks. Dolpan Gord Dibben wrote: I tested the code using Excel 2003 after InsertObjectCalendar 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 I am using excel2003 and the instuction says that by simply selecting from the active worksheet excel menu "Object" and further select "Calendar" it [quoted text clipped - 20 lines] Dolpandotcom 06/16/09 |
#25
|
|||
|
|||
General Excel question
Thanks. You can send to me the workbook with the Calendar using this email
below pls: and copy also Cheers, Dolpan. Gord Dibben wrote: email me and I'll send you a workbook with the Calendar Control in working condition. Or send me the workbook may be better. gorddibbATshawDOTca Change AT and DOT Gord It is now showing calendar control 11.0 instead of 9.0. Even with that, it does no disappear when you click a new cell different from the cell where the [quoted text clipped - 24 lines] Dolpandotcom 06/16/09 -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200906/1 |
Thread Tools | |
Display Modes | |
|
|