hello,
i have had to password protect a sheet due to colleagues constantly changing formulas linking from other sheets.

when protecting the sheet i ticked the box to allow filter and sort. i can filter the data but it wont allow me to sort the data into date order.

any help will be appreciated

thanks in advance

Adam