You haven't indicated how you want to fire this off, but a messagebox should do it.
In your code you could include this line at the appropriate place:
MsgBox "Please select the proper row to delete and then move to the worksheet I want you to."
(Or whatever you want it to say.) Chances are that all this could just be done with code instead of telling the user to do it.
Can you give an example? What would the user be doing - you could make a command button that the user would click that says "delete entry" and then you could make that button pull up a form that would allow him to enter which row he wants deleted, then the code could move the user to the page you want or a page he enters. Is that what you had in mind?