J
JanetW
I need to protect a worksheet to prevent users from editting certai
columns. It's a log, so I would like to allow them to use AutoFilter t
sort the log. So when I protect the worksheet, I check the box tha
says, "Allow all users of this worksheet to: Use AutoFilters".
Seems pretty straightforward, but when I then go to Data > Filter th
AutoFilter selection is grayed out.
What am I missing?
columns. It's a log, so I would like to allow them to use AutoFilter t
sort the log. So when I protect the worksheet, I check the box tha
says, "Allow all users of this worksheet to: Use AutoFilters".
Seems pretty straightforward, but when I then go to Data > Filter th
AutoFilter selection is grayed out.
What am I missing?