Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Ahhhhrrrr someone please help me :0)
I have created an excel template that I inserted an calendar object 9.0 I am using office 2000 Premium Then I created some code that displays the calendar when a specific cell is active and when you double click on the day in the calendar it enters the date in the active cell. Then the calendar hides when the cell is deselected. I placed this template on a shared drive for other employee's to use. The problem is that other employee's are receiving error messages First one is "compile error hidden module?: sheet #" Then if I unprotect the module the next error is "compile error can't find project or library" I have found that any machine that has Office Premium" installed works fine. There is no error (not even the first error message which I find strange because why would an install of office that is not premium limit you from running some vb code on a hidden module). I have found that any machine that does not have "Premium Installed" has the errors. I think it is related to the library not being installed in the non-premium machines. Questions: 1. Is there another calendar control or date picker that I might be able to use that is available to all Office installs? 2. Is there a way I can add the calendar control object to the template so that anyone that has opened the template will have access to it? 3. Is there an easy way to add the control to PC's that don't have the control and how would I do that? there are over 100 pc's that don't have premium so I prefer a solution that does not require touching each machine if possible. Thanks for any help or other ideas. I really appreciate it! Kelly |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Calendar control | Excel Discussion (Misc queries) | |||
Calendar control | Excel Discussion (Misc queries) | |||
Calendar Control | Excel Worksheet Functions | |||
Calendar Control 11.0 | Excel Discussion (Misc queries) | |||
Calendar Control 9.0 | Excel Programming |