How to get 'auto sort' (by Alf) to work in my worksheet

Thanks for trying but , unfortunately no change. You don't need to waste too much time on this, I can live with putting the colon in, It's the same wheteher the sheet is protected or unprotected, however, it will be protected when needed