I am working in an environment where certain spreadsheets are password
protected, but the developers do not know the passwords. Even if we did,
writing them into the code would be against policy as well.

For now, we are running Excel 2000. Our code can modify password-protected
sheets by setting UserInterfaceOnly = True, which does not require a password.

What about when we move to Excel 2002? Setting UserInterfaceOnly will no
longer work for us since we cannot provide a password.

Is there an alternative in Excel 2002 that will allow the code to make
changes to the spreadsheets that the end-user is not allowed to make?

Thanks!

Lee