Protect workbook for Excel 2002 and Excel 97

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

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
 
G

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
Click to expand...
message news:[email protected]...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Save as problem for Excel 97/2000 (with VBA-protection in excel 20 3
Problem using VBA for Excel to protect a Workbook with a password. 4
Saving in Excel 97 a workbook developed in Excel 2002 1
Converting workbook to run on German excel 6
Protect / Unprotect Sheet in Share Workbook Excel 1
Shared workbook opened in Excel 2002 on a Wk2 server with terminal services & opened Excel 97 on a N 0
Run code from another workbook 7
Problem using protect/Unprotect in excel 97 1

Top