How to fix Compile Error message?

[RJSIGKITS]

Hi Guys.

I have just bought a new computer, and have been transferring my files, but trying to use my main Excel Document, and it comes up with:
"Compile Error in Hidden Module: Sheet 22"

My sheet number 22 is the sheet with all of my data Validation lists on.

Can anybody please tell me what I need to do to sort this out?


Thanks in advance.

 

[RoryA]

Unprotect the code so the compiler can flag the actual error line.

 

[RJSIGKITS]

Unprotect the code so the compiler can flag the actual error line.

Thanks for your quick response, I have unprotected the the code, and it now comes up with an error in this:

Private Sub Worksheet_Change(ByVal Target As Range)Application.EnableEvents = False
If Not Application.Intersect(Target, Range("B12:B251")) Is Nothing Then
Target(1).Value = UCase(Target(1).Value)
End If
Application.EnableEvents = True
End Sub

It highlights the top line in yellow, then "UCase" in yellow as well..

 

[RoryA]

Sounds like a reference error - if you're getting a 'Can't find project or library' type error. Stop the code, click Tools-References and see if any of the checked references start with "MISSING:"

 

[RJSIGKITS]

Crikey, this is a nightmare - seems all of my coding is now flagging issues!
I'm using vlookup as well, and when I enter my logical test, it says:
"Can't find Project or Library" Then opens a 'References' window, highlighting a line that says "Microsoft Windows common controls-2 6.0 (SP6)" ...

... AAARRRGHHHH!!!

 

[RJSIGKITS]

Hi Rory.

Thank you - you were spot on, that's precisely the error I'm getting.
So, as well as the highlighted row as mentioned, there is also a "MISSING: BoxEdit 1.0 Type Library" in the list...

 

[RoryA]

If you aren't using those references, just uncheck them and try compiling the code.

 

[RJSIGKITS]

If you aren't using those references, just uncheck them and try compiling the code.

Oh.... Simple as that, and it's sorted. Thanks for your help!

 

[RoryA]

Glad to help.