ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel should carry cell protection to other office productivity pr (https://www.excelbanter.com/excel-discussion-misc-queries/99634-excel-should-carry-cell-protection-other-office-productivity-google-page-ranking.html)

Zzyzxensis

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

Dave Peterson

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