Password protect excel? Only people with password can edit

[dlowery06]

I've played with the password feature and it doesn't look like it is doing what I want it to do. Can a password be created for administrators to have access to edit the spreadsheet and employees only read the spreadsheet?

 

[Juan Pablo González]

You can have include a password, when you're Saving As, to enable/disable write access to the workbook.

IN Excel 2000:

File | Save As, Tools | General options, Write password:

 

[Mudface]

Click on File-SaveAs, the Tools button in the top right of the dialog box and select General Options. Enter a password in the Password to Modify box (check the Read-Only recommended option as well if you want) and then save the file. Anyone opening it will then have to enter a password to be able to modify it.

 

[dlowery06]

got it, thanks, i found what i was doing wrong after your reply

 

[Michael M]

It is against Forum rules to assist in breaking or bypassing passwords !!!