Question regarding Windows XP Pro and Excel 2003

[Mister H]

Hi All:

The office I work in are currently changing all our computers from

Windows 2000 Professional and Excel 2000

to

Windows XP Pro and Excel 2003

I now have a small problem (at least I hope it is small):

If someone that has a new computer opens and uses my spreadsheet it appears to works fine. They then save the document. Now when I open the file and Enable the macro it opens fine but as soon as I click a button to run the macro below I get an error message:

Compile error.
Can't find project or library

I then click OK and it takes me to:

rspn=

How can I fix this problem?

Sub AccessOtherSheets()
'''''''''''''''''''

     rspn = InputBox("Please Enter Your Password")
     If rspn = "access" Then
     ActiveWorkbook.Unprotect rspn
     Sheets("Access OTHER Sheets").Visible = True
     Sheets("Access OTHER Sheets").Select
    Range("A1").Select
     End If
End Sub

Also can anyone think of any other issue that could arise from the switching of our computers and our upgrade to Excel 2003?

THANKS,
Mark

 

[NateO]

Hi Mark,

It is an upgrade problem, you have a missing Library Reference (click Tools->References), which tend to be platform specific, one that the code you've presented doesn't appear to need. See the following:

http://www.mrexcel.com/board2/viewtopic.php?p=523739#523739

You see how that Reference that is selected starts with 'MISSING'? You've got one of those, remove that or reset it and you should be in like Flynn.

 

[Mister H]

THANKS NateO...

I will check out the link you gave me.

Can you think of any other issue that I might have due to the switch or should everything work once we are all using the same operating system and version of Excel?

THANKS for you help...
Bye 4 Now,
Mark

 

[NateO]

Hi Mark,

You are welcome.

I can't think of a whole lot off the top of my head, having done this. Usually Excel is fairly compatible as you upgrade, at least pre Excel 2007.

Backwards compatibility would be a bigger issue in my mind... But that's not a factor, here. Not sure though, if you run into a problem, feel free to ask.