General Excel question

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

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]
Dolpandotcom
06/16/09
 
D

dolpandotcom via OfficeKB.com

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 Insert>object>calendar
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 said:
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
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]
 
D

dolpandotcom via OfficeKB.com

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 said:
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
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]
 
G

Gord Dibben

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
calendar is inserted. Advice pls.

Thanks.
Dolpan

Gord said:
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
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
 
D

dolpandotcom via OfficeKB.com

Thanks. You can send to me the workbook with the Calendar using this email
below pls:

(e-mail address removed) and copy also (e-mail address removed)

Cheers,
Dolpan.

Gord said:
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]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top