Bug in programming - using toggle between read-only and write acce

  • Thread starter Thread starter NikkiS
  • Start date Start date
N

NikkiS

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/com...0f6e9c7&dg=microsoft.public.excel.programming
 
Insert a workbook on open event, to protect the sheet again.

--
HTH

Kassie

Replace xxx with hotmail
 
Back
Top