View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Lee S[_2_] Lee S[_2_] is offline
external usenet poster
 
Posts: 2
Default UserInterfaceOnly in 2000 versus 2002

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