Macro to delete rows ONLY if condition is met

[lealea1982]

Hi all,

I already have a macro that will delete the selected row when the user clicks the relevant button. What I want to build into the macro, is a safeguard that will prevent certain rows from being deleted. Basically in column A (hidden) there is a number above 0 on those rows that I don't want the user to be able to delete. So, say the user is currently in cell B* and clicks on the "delete row" button, the code needs to say "if cell A* is more than zero an error message will appear that the user then just presses OK to and that's that. If it's not more than zero then it will move on to my code to delete that row". Hope that makes sense!

Thanks for your help!

[AndyLitch]

Put this at the beginning of your sub

Please Login or Register  to view this content.