up vote 2 down vote favorite
share [g+] share [fb]

How many ways are there to password protect an excel file at the user level. Is there a way for a user to specify edit access via a password?

link|improve this question
feedback

migrated from stackoverflow.com Oct 19 '10 at 15:11

This question came from our site for professional and enthusiast programmers.

2 Answers

up vote 1 down vote

In Excel 2003, you can perform various types of password locking using the items under Tools | Protection. In particular, you can allow edit access to only certain ranges of cells using the Allow Users to Edit Ranges... item.

link|improve this answer
feedback
up vote 1 down vote

When you save the Excel File, there should be an Options button in the dialog that allows you to specify a password to open, and a password to modify.

If you wish only to lock certain cells of a spreadsheet. check out Tools -> Protection -> Protect Sheet. Protect Sheet will lock any cells that are marked as Locked in the Format Cells dialog.

link|improve this answer
Thanks this is what i was trying to remember – Craig G Jan 7 '09 at 17:53
You should mark this as the answer then. – qroberts Oct 19 '10 at 18:24
feedback

Your Answer

 
or
required, but never shown
discard