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