Macro/code to hide rows

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am making a complaint tracking form and want the users to be able to have a
completed row automatically hidden. Ideally this would happen via a command
button at the end of each row, or one central command button that they can
click and then select the row to be hidden, or select the row first and then
click the button. There will be around 200 active rows on this worksheet at
any given time, and I need the ability to have any one of the rows hidden
when it is completed. I have tried other code examples I found on here, but
none of them have worked as of yet. Any help is greatly appreciated. Thank
you.
 
Selecting a cell and clicking a button doesn't sound too automatic to me.

Why not just right-click on the row header and "Hide"?

If you could tell us how Excel would know a row is completed I am sure someone
could come up with event code that would hide the row automatically without
selecting and clicking.


Gord Dibben MS Excel MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hiding rows and printing 1
Hide columns based on row values 2
Automatically hide/unhide rows 5
hiding/unhiding rows 1
hide row based on cell value 2
Hiding/Exposing Rows based on a cell value 10
Hiding/Unhiding Rows Automatically 1
Hidden text in tables causes empty rows 0

Back
Top