compile error: can't find project or Library - autofix

[rpjwhite]

Hi,

I have a workbook that I am getting quite a few people to fill out and send back using a userform; however due to me getting clever it is calling for a new reference which I have loaded on my machine.
A quick look round the forum tells me how to fix it manually but is there a quick command to ensure certain references are loaded if they are missing when a userform initalises? I couldn't find a command for that?

Thanks

Robin

[Norie]

Robin

What reference is missing?

Is it one that's required in the workbook you distributing?

[rpjwhite]

Hi Norie

Microsoft Calendar Control 11.0

yes my new userform use it.

Thnx

[Norie]

Robin

You can use code to find out what references are set but that code wouldn't be able to run if there was a missing reference.

Have you looked into using an alternative to the MS Calendar Control?

[rpjwhite]

Norie

Shame I thought there was a way round it, oh well.

I am suing it to show a pop up calendar in my userform

R

[Norie]

If you Google you will find other examples of pop-up calendars that people have created to replace Microsoft's version.

[rpjwhite]

Thanks Norie
Will give that a shot.
R