By the way I used data validation to create a listox. Thanks again and again.

"JLatham" wrote:

Please define 'listbox' - are you referring to a control from one of the
toolbars (the Controls Toolbar or the Forms Toolbar) placed onto a worksheet
or on a user form? Or could you be referring to a list created using Data
Validation in a cell on a worksheet?

Basically you're going to need some code associated with an event triggered
by a change in your listbox to do the work for you.

"Chay" wrote:

How can I protect a range of cells after a listbox selection. Thanks, Chay