Locking cells in Excel 2003

HP 6120
November 20, 2008 at 01:31:28
Specs: win xp -sp2, 3Ghz Intel HT, 512 Ram,HP
Dear Concern,
I have an excel 2003 sheet filled with data.
Now i want others to add the data but not edit the old data expect me.
If some one can suggest me how to make this function work that after every data entry & save the cell should get locked automatically & only edit permission with me.
Some one suggested for an macro program as i am an ordinary user i don't know about programing.
It would be vey helpful if any one can provide the solution for this.

See More: Locking cells in Excel 2003

Report •

November 20, 2008 at 06:57:39
By default, when you protect a worksheet, all the cells on the worksheet are locked. You can however, lock only specific cells and ranges.

Enter "Unlock specific areas of a protected worksheet" in Excel Help, and it will explain the steps.

"So won’t you give this man his wings
What a shame
To have to beg you to see
We’re not all the same
What a shame" - Shinedown

Report •

November 20, 2008 at 12:36:26
Unfortunately, the only ways to protect and lock a cell after data has been entered is to either do it manually each time or to use a macro.

A Worksheet_Change macro or a Before_Save macro could be written to make this happen, but each user's machine would have be set to allow macros to be run. This can be difficult (but not impossible) to control, especially if you are sending the worksheet to users where you will not know the status of the security settings.

If you would like to see what one of these macros would look like, let me know.

Report •

November 22, 2008 at 02:54:54
Yes I am looking if any one can give an macro program so that the cell get locked automatically after entering & save, & only edit permission to administrator.

Report •

Related Solutions

November 22, 2008 at 16:28:21
A couple of questions first:

Are the users adding data at the end of certain rows or cells, thereby extending the UsedRange of the spreadsheet or are they adding data in a range that is in the middle of other data?

Do you want the cells locked only after the Save operation or do you want the cells locked as soon as the data is entered?

Are you sure that everyone using the spreadsheet will have macros enabled on their systems or at least have the ability to enable them?

It might help if you sent me a copy of the workbook along with an explanation of how and where a user enters data.

I've sent you an email address via Private Message.

Report •

January 1, 2009 at 09:00:17
Sorry for bumping it up, but does anyone know how to do it? What I want to do is exactly the same - normal users can only add data, but not remove or edit them without a password. Many Thanks.

Report •

Ask Question