Macro error

[Jeeremy7]

Hello,

I created a macro that was working just fine and for some reason it decided not to work anymore.
The error is:
Run-time error '-2147319767 (80028029)
Automatic error
Invalid forward reference, or reference to uncompiled type.

When I check debug it shows me the line there only calls a sheets.
sheets("XXX").Select

Not to sure why this error just appeared.
I saw that it could be because of VB6.0 but I have no Idea how to fix it as I do need to call that sheet..

Thanks !

Edit:
I also realised that the macros are in visual basic but don't appear when I press the macros button

 

[6StringJazzer]

Even though that line was highlighted, the error could be introduced somewhere else. Please show all of the code. Also consider applying code tags for better readability. Paste in the code, selected the code, click the VBA button on the edit controls.

 

[Jeeremy7]

That was the problem.
For some reason instead of putting sheets("XXX").Select I put sheet1.select and it worked. Very weird but it is what it is (I re typed the sheet name to make sure and the lag was still there, only for that specific sheet)