CODEWITHSUNDEEP
excelexcel-formulaoffice365
Anthony
Anthony

Reputation: 15

Lock cells after data entry NO VBA

is there a way to lock cells after a user enters data on the adjacent cell without using VBA?

for example the user enters "Y" on B1 and a time stamp generates on B2 I need B1 & B2 to lock right after and require a password for them to be edited.

Upvotes: 0

Views: 568

Answers (1)

Scott Craner
Scott Craner

Reputation: 152450

The short answer is: No

The Long answer is: Still No, but with the following explanation.

Native Formulas only effect the cells in which they are placed and only the values.

These formulas are live as in, any formula that will place todays date on completion of another cell will change with each calculation of Excel as TODAY() and NOW() are volatile. You cannot make them stay stagnate (Using circular references will not survive the restart).

Formulas, also, cannot change the format or locked setting of cells, even the ones in which they are placed. Nor can they protect and unprotect a sheet.

The only way to accomplish this is through vba in a Worksheet_Change event, where the code triggers on changes to the sheet.

Upvotes: 3

Related Questions