excel 2003 error>> compile error in hidden module: ThisWorkbook

  • Thread starter Thread starter clayton
  • Start date Start date
C

clayton

Hi, I created this worksheet in Office XP. Now I have a new compute
with WindowsXP pro and Office 2003. This worksheet opens fine on othe
machines but on mine I get

"compile error in hidden module: ThisWorkbook"

When I look at it in VBA and run it , it will stop on this line.

Else

response = MsgBox("This is my message to the user.", _
vbOKCancel)
If response = vbOK Then

What is different in Office 2003 to make it have an error now
 
Hi Clayton,
Hi, I created this worksheet in Office XP. Now I have a new computer
with WindowsXP pro and Office 2003. This worksheet opens fine on other
machines but on mine I get

"compile error in hidden module: ThisWorkbook"
Click to expand...

There's probably something missing on your machine. Click on Tools >
References and see if anything at the top starts with "MISSING: " If
so, try unticking that library.

Regards

Stephen Bullen
Microsoft MVP - Excel
www.BMSLtd.ie
 
Well, I am assuming that no one is having this problem...
Could this be a courpt file in Office or something? I know very littl
about excel so I am stumped.

This is my whole Workbook_Open statement
 
Wow, I was sure someone could help me here. This is the best resourc
site I've ever seen for excel. Hrmm... Guess I'll have to work aroun
it.. Just don’t make any sense..
 
Back
Top