LinkBack URL
About LinkBacks
I’m trying to write a macro that deletes the row of the active cell but if the selected cell is out of a specified range a message is displayed.
Any help is appreciated, the code I have so far is below.
Please Login or Register to view this content.
Macro to delete row within a specified range or disallow if out of range
I’m trying to write a macro that deletes the row of the active cell but if the selected cell is out of a specified range a message is displayed.
Any help is appreciated, the code I have so far is below.
Please Login or Register to view this content.
Last edited by Mayweed; 04-07-2011 at 01:51 PM.
Will it hurt anything if the user ignores the msgbox and continues anyway?
Life is like a roll of toilet paper. The closer it gets to the end, the faster it goes.
John Wright
As long as the user can only delete a row within the specified range (designated by selecting a cell in the desired row), the MsgBox can be ignored.
Re: Macro to delete row within a specified range or disallow if out of range
If I totally deny reading a post by shg concerning ws selectionChange events on another forum, I can honestly say that I've solved this one myself!
The only caveat that I'm aware of; if using this code on a protected worksheet, then cell B1 must be unlocked.
If it helps anyone, I've attached a workbook.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks