#1
|
|||
|
|||
Sort and filter on a protected sheet
Hello,
I am working on an Excel spreadsheet where I would like it to be possible to sort while the sheet is protected, as it contains formulas and will be used by multiple users. So far, I have only managed to add a macro that allows filtering and clearing filters, but I would also like sorting to be possible. Could you help me, please? |
#2
|
|||
|
|||
When you protect the sheet, there are a lot of additional options you can set for protected sheet. As much as I remember, allowing the sorting is one of them!
|
#3
|
|||
|
|||
dont work because i have a macro that add a line and protect the sheet again. So, i dont know what to do.
|
#4
|
|||
|
|||
Quote:
But in case you really use macros instead of VBA, then I'm not sure this is a way to go for you. Macros are quite limited tool! |
#5
|
|||
|
|||
Quote:
|
#6
|
|||
|
|||
Quote:
If someone Knows another better I would like to hear about it |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Sort Filter Problem | PomDave | Excel | 3 | 01-27-2022 03:36 AM |
SORT() and FILTER() functions missing | Ricko_uk | Excel | 5 | 08-24-2020 11:44 AM |
Size of filter sort box and open at 1st available row for new data. | mobile | Excel | 0 | 10-23-2016 03:39 AM |
Filter, Sort, Macro... what to do? | zingle | Excel | 3 | 10-17-2015 06:49 AM |
Forgotten Sort and Filter Criteria | rbdmg | Mail Merge | 0 | 10-31-2011 09:14 PM |