G
Guest
I create many spreadsheets for users. I unlock all the cells where they are
allowed to enter data and protect the sheet after that. Up to this point
everything is fine. But when I have autofilter attached to the table it
cannot be used by the users because autofilter only works when the sheet is
unprotected. Is there a way I can still protect the formulated cells and use
autofilter?
allowed to enter data and protect the sheet after that. Up to this point
everything is fine. But when I have autofilter attached to the table it
cannot be used by the users because autofilter only works when the sheet is
unprotected. Is there a way I can still protect the formulated cells and use
autofilter?