Trap Protect Message
Posted on 2013-01-23
With Excel 2007, I use vba that is triggered by a button on the worksheet to copy the last row and past it into the row just below it. I want to force the user to use the button to add a new row because of all the data validation. The worksheet is protected except for rows that they've entered data in and the new row.
If they try to start typing in a new row without using the button they get a message to use the button followed by the standard protect message prompting for a password. Can I get rid of that standard message or change it?
I know I could just past a lot of blank rows that would have the validation but I never know what the user will do and they might remove the validation so I prefer to use the button. Or is there another approach I could consider?