Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Toggle read only | Excel Discussion (Misc queries) | |||
Programming a toggle button | Excel Programming | |||
Toggle Read Only | Excel Programming | |||
Read Write Programming | Excel Programming | |||
How can a file be converted from Read-Only to Read/Write | Excel Discussion (Misc queries) |