Need a macro for hiding a row in a worksheet after entering the required information

[biju_u]

Hi,

I would appreciate if anyone could help me with a macro for hiding a row in a worksheet once the required information is entered into the row. For e.g. Data needs to be entered from A2 to H2 in a worksheet and once finished entering the information in H2, row 2 should hide automatically and should display only rest of the rows i.e. 3 onwards. This process should reapeat itself for the rest of rows.

Thanks,

Biju

[NeedForExcel]

Here!

Put this on the Worksheet Module -

Please Login or Register  to view this content.

And this on a regular module -

Please Login or Register  to view this content.

[sktneer]

You may also try something like this.....

Place the following code on Worksheet Module (Right click the Sheet Tab --> View Code --> Paste the code given below on the opened code window.)

Please Login or Register  to view this content.

And place the following codes on Standard Module. (On VBA editor --> Insert --> Module --> Paste the following code on the code window)

Please Login or Register  to view this content.

[biju_u]

Thanks a lot for your solution and it works.

[sktneer]

You're welcome.
If that takes care of your original question, please mark your thread as Solved by selecting Thread Tools (just above your first post) --> Mark thread as solved.