Excel Pop Up calendar

[alrymala]

I've set up a pop up calendar on an excel worksheet and it works fine on my computer. The problem is that sheet is to be used by several people and it turns out they don't have the calendar module so it gives them a compile error when they try to open the calendar.

Is there a way to get a pop up calendar working or passing the calendar control so it works across the board? Installing it on the other PCs is out of the question as these are locked down company PCs.

[Siddharth Rout]

use datepicker instead of calendar control

[alrymala]

Thanks for the reply, but it still doesn't work. Compile error for that as well.

[Siddharth Rout]

How are you adding that control?

[alrymala]

It's on a userform. I was able to find it in my list of Additional Controls but others don't seem to have it.

[Siddharth Rout]

Check if they have MonthView?

[alrymala]

Still no go, I checked on one of the other computers and see those controls if I try to create a new userform so I don't understand why it's still not working.

[Siddharth Rout]

probably because excel is not completely installed there

[alrymala]

So it's not possible to get this going by either including these modules or building it not dependant on those controls?

[Siddharth Rout]

Ok do this...

Search their pc for mscomct2.ocx. If it is there then register it. First copy it to System32 folder

To register it click on Start->Run and type

c:\windows\system32\regsvr32.exe c:\windows\system32\mscomct2.ocx

Once it is registered, check if you now have access to controls which you should have...

[alrymala]

This is to be used by people throughout my company's various offices... which are far away. So I don't have access to their PCs. Besides, they don't have admin rights to make that change.

[Siddharth Rout]

If this file is important then you need to request the administrator to install it... I did the same in my office...