ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Pop Up Calendar (https://www.excelbanter.com/excel-discussion-misc-queries/90291-pop-up-calendar.html)

JM

Pop Up Calendar
 
Hello,

When I email my workbook (or open on another computer) the pop up calendar
no longer works.

The error message reads:

"Compile Error: Can't find project or library"

The first line of code is highlighted as well as "Date" in "Calendar1.Value
= Date"

I used the code suggested by Ron de Bruin.

Please help me. Thanks!

Ron de Bruin

Pop Up Calendar
 
Not every user have this control on his computer
Read about it here
http://www.rondebruin.nl/calendar.htm

Aslo it is not working if you add the control in 2003 and send it to a Excel 2000 user.
If you create it in 2000 it is working correct in 2002-2003

--
Regards Ron de Bruin
http://www.rondebruin.nl


"JM" wrote in message ...
Hello,

When I email my workbook (or open on another computer) the pop up calendar
no longer works.

The error message reads:

"Compile Error: Can't find project or library"

The first line of code is highlighted as well as "Date" in "Calendar1.Value
= Date"

I used the code suggested by Ron de Bruin.

Please help me. Thanks!





All times are GMT +1. The time now is 12:00 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com