I need a macro to run on a set condition
Hi Mike, I appreciate the help. Just so I am on the same page, do I place the
code that you gave before the start of my existing code - which is:
Range("B9:I16").Select
ActiveSheet.Unprotect
Also what does - Then place a marker at the bottom - mean
I am pretty much a beginner at this
Thanks
"Mike H." wrote:
Place a line of code in the macro that runs when they click the button before
anything happens:
if cells(6,1).value<empty then
msgbox(prompt:="You may Not enter anything else, the file is full!",
title:="Entry Not Allowed", buttons:=Vbcritical)
goto theend
end if
Then place a marker at the bottom:
TheEnd:
end sub
"Savuti" wrote:
I have a macro assigned to an enter button on a spreadsheet. When the enter
button is pushed, data entered into row 1 (the data entry cell) is moved to
row 2 and so on until row 6. Rows 2 to 6 are locked out to prevent anyone
from accidentally deleting or overwriting data in those rows. I would like a
condition set that when data gets to row 6, the last row, a message box
informs that the list is full. And at that point when the enter button is
clicked the original macro does not run until the list is deleted. I do have
a macro for the deletion part.
Please help.....
|