Protect workbook for Excel 2002 and Excel 97
 

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!

Protect workbook for Excel 2002 and Excel 97
 

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)
www.rondebruin.nl



"Romuald" wrote in message ...
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!

Protect workbook for Excel 2002 and Excel 97
 

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)
www.rondebruin.nl



"Romuald" wrote in
message ...
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!


.

Protect workbook for Excel 2002 and Excel 97
 

Sorry I don't know
--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



wrote in message ...
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)
www.rondebruin.nl



"Romuald" wrote in
message ...
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!


.