T
Tsi Waipahu
I have a worksheet was setup to allow users to access certain ranges even the sheet is protected. I deleted one of the ranges from the Allow Users Edit Ranges windows which users should not have access to it anymore, however, the deleted range was accessible even the sheet is protected. Why? Just to experiment, I deleted all ranges from the Allow Users Edit Ranges windows, therefore, users should not be able to edit the entire worksheet when the sheet is protected, however, I was able to access all ranges that previous setup to allow users to edit. Any ideas?