I want to set up protection on a worksheet, but when I try to add the range/s of cells I get to an amount, then it resets itself. I am assuming this is the maximum limit of cells for the range.
If I create a 2nd and 3rd range, is it possible to set to default all 3 ranges when the workbook is opened?
How ?

My aim is to enable ONLY the selected range of cells to able to have data entered/removed.
All other cells are NOT available.
BUT,, there's more....

I need the code for emailing a layout in a email body to STILL be available to the user.
The worksheet has numerous formulas and references to other cells, and I do not want these to be modified.

Possible?

Corey....