NonActiveX DateTime Picker: Conpile error in hidden module

**vbarookie** · 03-30-2011, 01:40 PM

I downloaded a nonActiveX DateTime Picker (frmCalendar) from a website recommended by RoyUK and managed to get it to work on my workbook and a few other users' workbook. Did tests on XP (Excel 2003) and on Vista (Excel 2007) - both came out without any issues.

However a few users running Vista/Excel 2007 keep getting the error message:

"Compile error in hidden module: ThisWorkbook"

I checked the contents of ThisWorkbook and it was unchanged from before I implemented the new frmCalendar. I removed all traces of the previous DatePicker implementation which was based on mscal.ocx.

I know I am not giving a lot of information here but can someone tell me where to start looking for possible problems. Thanks.

Regards
Phil

**jwright650** · 03-30-2011, 01:57 PM

Any chance that you can attach a sample workbook?
It's easier to troubleshoot that way.

**jwright650** · 03-30-2011, 01:59 PM

Here is a workbook with royUK's calendar in it...see if you can open the calendar in this file.

**vbarookie** · 03-30-2011, 07:12 PM

Originally Posted by jwright650

Any chance that you can attach a sample workbook?
It's easier to troubleshoot that way.

Unfortunately I can't as the workbook has client information. The sample code which RoyUK provided worked for me. I was hoping someone can tell me where to start looking for the problem. Like for example, is there anyway to force Excel to produce more detailed error messages or is there an Excel log file with more error details.

Phil

**vbarookie** · 03-30-2011, 07:26 PM

jwright650:

I looked thru the sample code u provided and noted that the Calendarfrm implementation in your sample code does not make use of a class module whereas the version I download from the website recommended by RoyUK required me to create a class module with one procedure CmdBtnGroup_Click().

In anycase, I will look into your version of Calendarfrm and test it on those laptops that are failing in the version I am using.

Thanks for the tip.

Phil