Lock selected range.

Last Edited By Krjb Donovan
Last Updated: Mar 05, 2014 09:44 PM GMT

QuestionEdit

i want to lock selected cell & selected range of cell which shouldnt edit in later. pls advise how to process this scenario?

thx.

AnswerEdit

wasfiathhar

It takes a few procedures but this is what I do.

First-- go toolbar/tools/protection/protect sheet and protect the sheet.

Second-- go to toolbar/tools/protection/protect sheet and unprotect sheet

Third-- clic on all cells (intersection of the row and column headings) then go to toolbar/format/cells/protection and unclic the locked box.

Fourth-- paint or make active the cells that you want to lock and go to toolbar/format/cells/protection and clic the locked box

Fifth--go to toolbar/tools/protection and protect the sheet.

Now only the cells that you have selected to be locked should be locked the rest should be unlocked.

There may be an easier way, but this works for me.

Advertisement

©2024 eLuminary LLC. All rights reserved.