S
Sandra
Hi,
Searching through the discussion group I can see that several people seem to
have problems with the autofilter show all feature. I have a protected
worksheet for a shared workbook. Although other users are able to
Autofilter, their autofilter setting is saved when they close the file.
Because the worksheet is protected, SHOW ALL is unavailable which means that
the next user has to bring all the filters to ALL before being able to set
their own autofilter (which will be saved when they save the workbook). It's
kind of annoying as a lot of users are VERY novice to Excel (2003). I have
tried adding code to the on OPEN VBA as someone has suggested, but while it
works well when the worksheet is not protected, it stops working when I
protect it. Does anyone know a way to solve that problem? Any help would be
appreciated as I have run out of options.
Thanks
Sandra
Searching through the discussion group I can see that several people seem to
have problems with the autofilter show all feature. I have a protected
worksheet for a shared workbook. Although other users are able to
Autofilter, their autofilter setting is saved when they close the file.
Because the worksheet is protected, SHOW ALL is unavailable which means that
the next user has to bring all the filters to ALL before being able to set
their own autofilter (which will be saved when they save the workbook). It's
kind of annoying as a lot of users are VERY novice to Excel (2003). I have
tried adding code to the on OPEN VBA as someone has suggested, but while it
works well when the worksheet is not protected, it stops working when I
protect it. Does anyone know a way to solve that problem? Any help would be
appreciated as I have run out of options.
Thanks
Sandra