Compile Error in hidden module: sheet2

[cuslyguy]

Good morning all,

I receive this error when trying to use a button within a worksheet that has some VBA attached to it which is designed to convert some info on the worksheet to a flat .txt file and send it to a specified location.

The worksheet/button/vba was originally built using excel 2003 and I am trying to do this in excel 2010. The error does say that it might not be compatible with the current version.

I have to get this to work!

Help please >.<

 

[shg]

What's the code?

 

[Andrew Poulsom]

If you select your workbook in the Visual Basic Editor Project window and choose Tools|References are any marked as MISSING?

 

[cuslyguy]

I was thinking down the same path Andrew. The thing is - I went to look there and see if anything had been checked as missing and I can't even get there to look. I go to tools|References and the References option is grayed out. I can't even click on it.

 

[cuslyguy]

shg, the code is extensive. too extensive to post here I think

 

[Andrew Poulsom]

Is the VBA Project protected?

 

[cuslyguy]

ok think I figured it out Andrew, thanks to your help - I think I was unable to get to references because I was in object debugger mode. I went back into the project through the developer and was able to remove the missing reference. thank you!