Date Picker component

[Anelisa Gomes]

Hi,

Could someone help me with this issue?

I am developing a VBA Macro and I add a date picker component on the sheet.

But when I test this file on another computer this date picker disappear.

What's the best way to link this component to the sheet and every time I
send this file for other people it works fine???

Thanks a lot.

Anelisa

 

[Crowbar via OfficeKB.com]

The Date Picker is part of the mscomct2.ocx file

this is found in your windows\system folder

If the computer you are sending the file to doesn't have this active x file
then they wont be able to use the date picker

This file needs to be copied to there system folder

Then a reboot is required

http://www.apofficesolutions.com

--
Anthony Prescott
http://www.apofficesolutions.co.uk

Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.aspx/excel-programming/200903/1

 

[Dave Peterson]

Maybe you're using the calendar that only works when Access is installed? And
you have Access, but the recipients don't????

Maybe you can use a free replacement.

Ron de Bruin has some notes:
http://www.rondebruin.nl/calendar.htm