I am using excel 2003 with a shared workbook. With a macro i enter info into
a userform to place data into a filtered list, the sheet is protected.
This works fine until the macro tries to change the auto filter to display
the new entry. The macro fails because the sheet is protected, while trying
to use the auto filter. When I protect the sheet i have the "allow use of
auto filter" box checked.
I cannot unprotect the document as it is shared, I also need to protect
formulas in the worksheet. It will allow me to change the auto filter
manually, however I am trying to do this with a macro. Any ideas???