Protect workbook for Excel 2002 and Excel 97

  • Thread starter Thread starter Romuald
  • Start date Start date
R

Romuald

Hello!

I have an Excel workbook developed with Excel 97. Now i
use Excel 2002. When I modify my workbook with Excel 2002,
it works properly on office 97 except when I protect my
workbook. It seems that the encryption algorithm used to
protect the workbook is not supported on Excel 97.

Should I use the SetPasswordEncryptionOptions method?
In that case, which parameters should I use?

thnaks for your help!
 
If you protect your VBA project in Excel 2002 you can't unprotect it in 97.
Protect you VBA project in Excel 97 and you can open it in 97-2003
 
Evenif I specifiy an compatible algorithm with
SetPasswordEncryptionOptions function
(http://msdn.microsoft.com/library/default.asp?
url=/library/en-
us/vbaxl10/html/xlmthSetPasswordEncryptionOptions.asp)
?


-----Original Message-----
If you protect your VBA project in Excel 2002 you can't unprotect it in 97.
Protect you VBA project in Excel 97 and you can open it in 97-2003

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)




"Romuald" <[email protected]> wrote in
Click to expand...
message news:[email protected]...
 
Back
Top