Data Validation based on cell visibility

andrewb90

Well-known Member
Joined
Dec 16, 2009
Messages
1,067
I have a simple macro that hides a few rows. When those rows are hidden, I need a way to restrict any data entry until those rows have been unhidden. I am thinking data validation, but I have no idea how I would make that work.

When rows 16:17 are hidden, I need to restrict any entry in cells D12:O15

Any ideas would be greatly appreciated.

Andrew
 

Some videos you may like

Excel Facts

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.

Watch MrExcel Video

Forum statistics

Threads
1,099,699
Messages
5,470,233
Members
406,686
Latest member
BNR_ 1980

This Week's Hot Topics

Top