![]() |
Excel should carry cell protection to other office productivity pr
When I protect a worksheet in Excel, it locks those cells, but when I have to
open it up in a different office program such as OpenOffice or QuattroPro, the password protection is automatically removed. The cells are still locked, but can be easily unlocked, as the password is removed and one must only tell the program to remove the sheet protection. No password prompt comes up. This is very inconvenient as one could take a protected excel file, open it up in QuattroPro, remove the protection, and open it back up in Excel, ready for editing. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...lic.excel.misc |
Excel should carry cell protection to other office productivity pr
I don't think Microsoft has any way of changing OpenOffice or QuattroPro. I
would think that those programs should treat the protection "nicer" if they were good citizens of the world <g. Zzyzxensis wrote: When I protect a worksheet in Excel, it locks those cells, but when I have to open it up in a different office program such as OpenOffice or QuattroPro, the password protection is automatically removed. The cells are still locked, but can be easily unlocked, as the password is removed and one must only tell the program to remove the sheet protection. No password prompt comes up. This is very inconvenient as one could take a protected excel file, open it up in QuattroPro, remove the protection, and open it back up in Excel, ready for editing. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...lic.excel.misc -- Dave Peterson |
All times are GMT +1. The time now is 04:46 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com