I have a 100-row spreadsheet (w/o password) consisting of:
A. Unlocked/non-formula cells in columns B through D
B. Locked/formula cells in columns E-K (values derived from user’s text entries in columns B through D)
C. Data Validation at column N (referenced to a range list containing a checkmark and a blank)
I need a button-based macro that will poll column N for checkmarks, and for each row having one in column N, do the following:
A. Lock that row’s cells in columns B through D
B. Replace the formulas in the column E through K cells with their values (and maintain their locked condition)
The purpose of this macro is to prevent future changes to the row's entries and calculations, once the user placed a checkmark in column N.
I've attempted to duplicate similar coding found on the web, but being a non-expert at VBA, the frustration has beat me. Any assistance would be greatly appreciated . . .