Ranges in protected worksheet will not reset

[Waikele Lin]

I have a worksheet setup allow users to edit certain range areas when the sheet is protected, however, after those ranges deleted users still can edit even with the sheet protected. Any idea?

 

[Frank Kabel]

Hi
how have you deleted this range?

 

[Waikele Lin]

Tools>Protection>Allow Users to Edit Ranges..>Clik on the Delete button after the range is selected

Thanks

 

[Waikele Lin]

Tools>Protection>Allow User to Edit Ranges...>select range and Delete

 

[Waikele Lin]

Tools, Protection, Allow Users to Edit Ranges, select range and Delete

Thanks