I have a protected workbook, in which users should be able to filter various data points. I have the AutoFilter turned on prior to protecting the sheet AND I select "Use AutoFilter" when I protect the sheet. Immediately after the sheet is protected, everything works. However, if the workbook is closed and reopened, the autofiltering is disabled. I have to unlock the sheet and relock it, reselecting "Use AutoFilter". This is obviously not ideal.
Any ideas why this might be happening and what I can do to fix it? I do not believe it was an issue in the same document a few days ago.
Any ideas why this might be happening and what I can do to fix it? I do not believe it was an issue in the same document a few days ago.