Macros not working due to "invalid forward reference, or reference to uncompiled type"

[Obewan]

I have been using this macros for years and get this error. I deleted the sheet and replace it and then it gets past this goes onto an error in the next sheet, and so on until I've deleted 3 sheets then pasted them back in - the issue is the sheets have a lot of vlookup formula's to the old sheets so it will take me hours to fix them all.

Also all my macros have disappeared from my macro list

Any quicker suggestions?

 

[Joe4]

Are you, per chance, using a new computer, or did you recently upgrade your operating system?

Take a look at some of the solutions posted here: Invalid forward reference, or reference to uncompiled type

 

[Obewan]

Nope. Same computer for years.

 

[Joe4]

Nope. Same computer for years.

Did you investigate the various solutions provided in that thread?
It seems that there may be a myriad of reasons for getting that message, and different solutions worked for different people.

Is it only that one workbook having issues?
It is possible that you have have workbook corruption, and need to create a new workbook.