Is there anyway I can prevent autofill from applying formats to a cell range
when that cell range is protected? The worksheet is protected - the user can
chnage values but cannot apply formats.

Thanks