LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 10
Default Calendar Control

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Calendar control cufc1210 Excel Discussion (Misc queries) 3 September 30th 09 02:48 PM
Calendar control Marcus Excel Discussion (Misc queries) 1 December 5th 07 07:53 AM
Calendar Control Roleeb Excel Worksheet Functions 7 March 19th 06 09:15 AM
Calendar Control 11.0 MCorn Excel Discussion (Misc queries) 1 August 3rd 05 06:04 PM
Calendar Control 9.0 Brad[_10_] Excel Programming 3 December 15th 03 06:39 PM


All times are GMT +1. The time now is 02:20 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"