T
Travis
I have three worksheets going on with dynamic content between all three
worksheets (data is entered on sheet and then shows up on another sheet). I
manually protected individuals cells that contain these formulas so a person
could not inadvertently "screw things up." (Format/Protection/then clicked
"Locked"). I then activated the protection feature for the entire worksheet
(Tools/Protection/Protect Sheet).
On the top of each worksheet sheet I activated the AutoFilter function so
that each column in that worksheet can be filtered. When I click on the
AutoFilter drop down menu I am able to filter each column by the lower
options (All, Top 10, Custom, Blanks, Non Blanks) but I cannot use the two
top options (Sort Ascending, Sort Descending).
Is there a way to have the protection of formulas in individual cells and
also have the ability to utilize the full functionality of the AutoFilter and
sorting features?
Thanks!
worksheets (data is entered on sheet and then shows up on another sheet). I
manually protected individuals cells that contain these formulas so a person
could not inadvertently "screw things up." (Format/Protection/then clicked
"Locked"). I then activated the protection feature for the entire worksheet
(Tools/Protection/Protect Sheet).
On the top of each worksheet sheet I activated the AutoFilter function so
that each column in that worksheet can be filtered. When I click on the
AutoFilter drop down menu I am able to filter each column by the lower
options (All, Top 10, Custom, Blanks, Non Blanks) but I cannot use the two
top options (Sort Ascending, Sort Descending).
Is there a way to have the protection of formulas in individual cells and
also have the ability to utilize the full functionality of the AutoFilter and
sorting features?
Thanks!