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

[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

 

[Stephen Bullen]

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"

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

 

[clayton]

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

 

[clayton]

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..

 

[Debra Dalgleish]

Stephen Bullen posted an answer to your original question:

http://groups.google.com/groups?&[email protected]

Some messages don't seem to make it through to the Excel forum, so if
you're posting through there you may miss things.