I suppose you would want to connect a button or a hot key to the first two macros.

Also some administrative stuff...

please use the code tags when entering code. (select the text and press the # above where you type)

And give the thread a meaningful title - almost everyone who posts a thread here needs help tweaking a macro so it is a very bad term for people to search whether they are trying to help you or to benefit from any insights that might come from the discussion.

I also suggest you don't call hiding rows "deleting rows" - it is unnecessarily confusing if you go back to it at a later stage.