Excel Sheet Lockout
November 23, 2007 11:07 AM Subscribe
I have a spreadsheet that I want to lock after a certain amount of data is entered. It needs to be an auto lockout as I cannot count on the user to stop entering data after a certain point. MI
posted by lampshade to Technology (2 answers total)
OK, so let's just say that I have 3 columns with 10 rows. All 30 rows will be filled and when that happens, all editing is disabled.
I was goofing with some VBA with works surprisingly well but how would I get something like this to trigger when cell C10 is filled in?
Here is the little code snippet
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address <> dtval Then Target.Formula = dtval
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
dtval = Target.Formula