IT Professionals' Lounge

Lock cells in Excel

•

Join Date: Jun 2007

Posts: 3

Reputation: Luma is an unknown quantity at this point

Solved Threads: 0

Luma

Offline

Newbie Poster

Lock cells in Excel

Jun 2nd, 2007

Hi All!! Plse HELP!!

I need to avail various ranges on different sheets in an in Excel 2003 workbook for users to type in. However, I need the cells to be locked upon saving of workbook. How do I do it?

Thanks
Luma

•

Join Date: Jul 2005

Posts: 4,845

Reputation: joshSCH is on a distinguished road

Solved Threads: 10

joshSCH

Offline

Banned

Re: Lock cells in Excel

Jun 3rd, 2007

Tools-protection gives you 'locking' options.. is this what you mean?

•

Join Date: Jun 2007

Posts: 3

Reputation: Luma is an unknown quantity at this point

Solved Threads: 0

Luma

Offline

Newbie Poster

Re: Lock cells in Excel

Jun 3rd, 2007

Hi joshSCH,

No. What I mean is that I need a script/code than runs "on change" locking only the changed cells. In other words, the user should be able to complete certain ranges, and upon saving, the changed (completed) cells should be locked, preventing future editting.

Last edited by Luma; Jun 3rd, 2007 at 12:56 pm.