create Button to Delete Rows, Please Help

[paata01]

Hello everyone,
can you please help me. I want to create Macro in VBA that will delete specific rows in excel. this is what I want to do
I am working on t-shirts excel file, I want to have two options there "MEN" and "Women", when I click men it should delete all woman rows. I have know specific rows which should be deleted. How can I do something like this? from filter it takes a lot of time to delete manually.

 

[paata01]

Thanks, I did it and it hides and unhides, but when I save as CSV, hidden row is still there

 

[Jonmo1]

Well, since you're doing 'Save AS'
Then the original data is still there.

So maybe do a normal save BEFORE deleting rows.
Then delete the rows and SaveAs CSV.

If you have to undo, you can copy from the original back into the CSV.

 

[paata01]

Thanks for help, what about EXCEL UNDO BUTTON. when I delete rows manually, I can click undo and go back. can userform do something like this. I have a lot of data and once its modified I can't copy from orginal CSV.

 

[Jonmo1]

No, you can't undo actions that were done by a macro.

 

[paata01]

ok, if not possible. I will create worksheets with two sets of data, its easier I think.
Thank you

 

[Jonmo1]

You're welcome.

Yep, that's the only thing you can really do.
Keep a copy of the original and restore from the copy if you need to undo.