Protect workbook for Excel 2002 and Excel 97

[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!

 

[Ron de Bruin]

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

 

[Guest]

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

message news:[email protected]...

 

[Ron de Bruin]

Sorry I don't know