Password error after file opens
 

I sent a colleague an Excel 2000 file with password protected sheets
containing 3 macros. The file opens but he gets the Run time error 1004
"The password you supplied is not correct. Verify that the CAPS LOCK key is
off and be sure to use the correct capitalization"
He has not supplied a password so if the file works OK on other machines,
how come it does this on his machine?

Thanks for your cooperation.

Is the password in quotes? "mypassword"

--
Don Guillett
SalesAid Software

"Pennington" wrote in message
...
I sent a colleague an Excel 2000 file with password protected sheets
containing 3 macros. The file opens but he gets the Run time error 1004
"The password you supplied is not correct. Verify that the CAPS LOCK key
is
off and be sure to use the correct capitalization"
He has not supplied a password so if the file works OK on other machines,
how come it does this on his machine?

Thanks for your cooperation.

Yes the password is in quotes

"Don Guillett" wrote:

Is the password in quotes? "mypassword"

--
Don Guillett
SalesAid Software

"Pennington" wrote in message
...
I sent a colleague an Excel 2000 file with password protected sheets
containing 3 macros. The file opens but he gets the Run time error 1004
"The password you supplied is not correct. Verify that the CAPS LOCK key
is
off and be sure to use the correct capitalization"
He has not supplied a password so if the file works OK on other machines,
how come it does this on his machine?

Thanks for your cooperation.