HOW TO AUTOMATICALLY HIDE A LINE

  • Thread starter Thread starter SHADOW
  • Start date Start date
S

SHADOW

IS IT POSIBLE IN AN EXCEL WORK SHEET
TO ARRANGE WHETHER A LINE WILL BE AUTOMATICALY HIDDEN OR UNHIDDEN
BASED ON THE VALUE OF A CERTAIN CELL?
 
Yes, it is possible using event code or a macro.

How is the value of the "certain cell" derived?

By calculation or by manual input?

Drop the Caps Lock and post back with details...........certain cell
address, which row to hide and answer to questions above.


Gord Dibben MS Excel MVP
 

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

hide columns/rows/cells on open 4
excel 2
Find last row with hidden rows 2
VB Code to hide and unhide rows 2
How to keep hidden columns hidden using protection 1
Macro to hide sheets based upon cell value 3
Hide row code help 1
Expand and collapse rows 7

Back
Top