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

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