I should have been more specific. The code works fine with
XL2K on a Win98 or WinNT machine, but does not work using
XL97 on a Win98 or WinNT machine. I had the "verified
password" in the post to indicate that I was using the
write password, it's not part of the code.

Rohit
-----Original Message-----
Hi Rohit,
I'm using NT4 with Xl2k at work, and the below code works
fine. I'm assuming you dont have the "(verified
password)"
in the coding. If you do, you may want to remove it or
put
a ' in front of it to comment it out.

HTH's.

-----Original Message-----
Hello All,

I have code that I wrote in XL97 that works fine when I
run it on a Win 2K pc but fails on a Win 98 or WinNT 4.0
pc. Here's the line of code which fails and the
associated
run-time error. The code is executed from a button on a
userform.

Private Sub ImportPPSPayrollFile()
***some code here***
ActiveSheet.Unprotect Password:="ppsproofpay"(verifed
password)
***some code here***
End Sub

Run-time error '1004' - Unprotect method of Worksheet
class failed.

Any thoughts on why this might be happenning??

Thanks in advance,
Rohit Thomas
.

.