Question regarding Windows XP Pro and Excel 2003

Mister H

Well-known Member
Joined
Mar 6, 2002
Messages
1,507
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?

Code:
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
 

Some videos you may like

Excel Facts

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce

NateO

Legend
Joined
Feb 17, 2002
Messages
9,700
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

Well-known Member
Joined
Mar 6, 2002
Messages
1,507
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 :biggrin:
 

NateO

Legend
Joined
Feb 17, 2002
Messages
9,700
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. ;)
 

Watch MrExcel Video

Forum statistics

Threads
1,126,888
Messages
5,621,434
Members
415,839
Latest member
faraji

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top