| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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! |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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! . |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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! . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2002: Can I protect the whole file in a single step ? | Excel Discussion (Misc queries) | |||
| Excel 2002: How to write protect a cell using password ? | Excel Discussion (Misc queries) | |||
| How do I protect a single cell in Excel 2002? | Excel Discussion (Misc queries) | |||
| Excel 2002 "Protect Sheet", but Allow "Insert Comments"? | Excel Worksheet Functions | |||
| Excel 2002 "Protect Sheet", but allow "Hide Columns"? | Excel Worksheet Functions | |||
Hybrid Mode
