Unlock Code

[Guest]

I created an Excel Program with VBA in a Windows 2000, Excel 2000
environment. The VBA goes into one sheet and unlocks that sheet with a
password, performs some procedures, then re-locks the sheet with a password.

A user who has Windows 95 and Exel 97 is trying to run this program. It
gives a "Unprotect failure (or something)" error. If I manually unlock that
sheet, the code runs fine. Does Windows 95/Excel 97 have a problem with
unlocking sheets with a password by way of VBA code? If so, what do I do?

SDC

 

[Don Guillett]

Here is an xl95 unlock that works fine

Sheets("INPUT").Unprotect Password:="yourpassword"

Perhaps you should copy/paste the code here for comments.