Bug in programming - using toggle between read-only and write acce
At my company, we use passwords to restrict users from having write access,
while still allowing them to view the spreadsheet with read-only. In Excel 2003, if a user was in a document as "read-only" and used the toggle button to switch to "write access", he was prompted for the password, and the file would switch to write access. The next time the file was opened, the password prompt would still pop-up. This is not the case in 2007. When a user toggles between read-only and write access in 2007, saves the file, and closes it; the next time the file is opened there password prompt does not appear and any user can have write access. This has become an issue with regards to the security and access controls. ---------------- 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...el.programming |
Bug in programming - using toggle between read-only and write acce
Insert a workbook on open event, to protect the sheet again.
-- HTH Kassie Replace xxx with hotmail "NikkiS" wrote: At my company, we use passwords to restrict users from having write access, while still allowing them to view the spreadsheet with read-only. In Excel 2003, if a user was in a document as "read-only" and used the toggle button to switch to "write access", he was prompted for the password, and the file would switch to write access. The next time the file was opened, the password prompt would still pop-up. This is not the case in 2007. When a user toggles between read-only and write access in 2007, saves the file, and closes it; the next time the file is opened there password prompt does not appear and any user can have write access. This has become an issue with regards to the security and access controls. ---------------- 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...el.programming |
All times are GMT +1. The time now is 09:18 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com