Need Macro to Auto hide rows

[cmwood]

Hello,

I am trying to write a macro that will hide the row that "Complete" is selected in. So in column "M" cells there is a drop down that has the options Complete, Not Complete and Follow-up. I want the row that is completed to hide when "Complete" is chosen. Everything I have done has failed. I am using excel 2010.

Thanks for your help, I need it.

[cmwood]

I tired this but when I hit run, its acting like I don

Please Login or Register  to view this content.

[cmwood]

This seems to work but I have to run it for it to hide the completed. It doesn't do it in real time

Please Login or Register  to view this content.

[arlu1201]

CMWood,

Welcome to the forum.

I have added code tags to your post. As per forum rule 3, you need to use them whenever you put any code in your post. Please add them in future. If you need more information on how to use them, check my signature below this post.

[Patnaik]

@cmwood

Hi

Try to put the code in the Sheet which sheet you want to run the above code and also your first code also working

Please Login or Register  to view this content.

Hope it clear

Thanks

SP

[arlu1201]

Try this code

Please Login or Register  to view this content.