Unlock Code

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
Here is an xl95 unlock that works fine

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

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