Code for Multiple Named Ranges for Data Validation

**tigeravatar** · 06-08-2011, 12:17 PM

Lost,

The code only runs when the workbook performs a calcuation, so there'd have to be a cell that has a formula in it, otherwise the workbook is just changing, not calculcating. To run the code manually, change the sub name and put it in a standard module, then run it. Additionally, this line of code:

        wsBigList.Visible = xlSheetHidden

Makes the worksheet hidden. You can view it by right-clicking any worksheet tab and selecting Unhide.

Hope that helps,
~tigeravatar

**leaning** · 06-08-2011, 12:57 PM

TigerAvatar,

Got it.

Incidentally, in the Test3 file posted earlier, I put =Now() (to force a recalculation) in one of the cells. I closed the workbook and then reopened it. The whole thing was flickering and I had to CTRL-ALT-DEL to get it to stop.

So, I put a button on it. It is an extra step the user has to do, but they still don't have to manually enter names in that cell.

If you don't see a better way to go, I think this thread is solved.

Thanks for your help!

Respectfully,

Lost