Excel and Password for Editing

Solved
Grilom Posted messages 186 Status Membre -  
l_intrus Posted messages 3103 Status Membre -
Hello, hello ^^

So here it is…
I would like to protect my Excel file with a password while allowing reading (but not writing).

It wouldn't be for high protection, just to prevent anyone from accidentally modifying the sheet.

For Excel, there is an option: ==> Save As ==> Tools ==> Password to modify

This option would suit me perfectly, but there is a problem: When I do this, the drop-down menus are no longer available (I click on the tab, but nothing happens)…

Do you have a solution please? ... Thank you in advance!
Configuration: Windows XP Internet Explorer 6.0

3 réponses

l_intrus Posted messages 3103 Status Membre 440
 
Hello, go to Tools -> Protection -> Protect Sheet and there you can select certain allowed actions.
2