G
Guest
Scenario
=======
excel 2002 spreadsheet has calender control and date and time picker
from mscmctl2.ocx (not sure if I have correct ocx, using a hotel
computer that can not find appropriate kb article probably because
it is set up improperly)
click the appropriate column, the date and time picker,
and the calendar work fine
e-mail spreadsheet to someone else ... it fails ...
look at the form on their vba editor/ide, can
NOT see calendar or date time picker
[appropriate .ocx WAS installed, and
vba reference is properly set]
e-mail spreedsheet from pc that can
NOT see it to another pc, it DOES work
and in vba ide, the calendar and
date/time picker ARE viewable
On PCs where this fails, error message is
something like "compile error ... method or
data member NOT found"
also, even though ocx is properly installed,
tools, additional controls is greyed out
ideas? help? thank you!!!
=======
excel 2002 spreadsheet has calender control and date and time picker
from mscmctl2.ocx (not sure if I have correct ocx, using a hotel
computer that can not find appropriate kb article probably because
it is set up improperly)
click the appropriate column, the date and time picker,
and the calendar work fine
e-mail spreadsheet to someone else ... it fails ...
look at the form on their vba editor/ide, can
NOT see calendar or date time picker
[appropriate .ocx WAS installed, and
vba reference is properly set]
e-mail spreedsheet from pc that can
NOT see it to another pc, it DOES work
and in vba ide, the calendar and
date/time picker ARE viewable
On PCs where this fails, error message is
something like "compile error ... method or
data member NOT found"
also, even though ocx is properly installed,
tools, additional controls is greyed out
ideas? help? thank you!!!