honestlyfungirl
New Member
I am trying to procect a page but still be able to use the filter drop down box and sort the information. I would love any help I can get.
Protect page/Sort/Filter Drop Down
- Thread starter honestlyfungirl
- Start date
honestlyfungirl
New Member
Oh and my boss said I can't figure this out. Out to get the job done and to show him that I can do it.
When you protect the sheet, you are presented with a list of options that you would like to leave enabled. Among those is the list to enable AutoFilter, which will let you use the filter drop downs.
Unfortunately, Sort is a different matter. While it does appear as an option when you protect the sheet, it will only let you sort cells that are unprotected. As this is probably not the case for you, you may be stuck here.
Possible work around would be to create some short macros that do something like
[pre]
[/pre]
But that option depends on other factors (macros enabled, shared workbook, etc).
Unfortunately, Sort is a different matter. While it does appear as an option when you protect the sheet, it will only let you sort cells that are unprotected. As this is probably not the case for you, you may be stuck here.
Possible work around would be to create some short macros that do something like
[pre]
Code:
PsuedoCode
ActiveSheet.Unprotect
SortData
ActiveSheet.ProtectBut that option depends on other factors (macros enabled, shared workbook, etc).