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.



Insert a workbook on open event, to protect the sheet again.



Replace xxx with hotmail

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question