Has anyone come up with a way to code up this functionality to work in Excel 97?
Essentially, I need to protect a sheet, but allow AutoFilter to be used for viewing purposes. In Excel 97 this is not permitted (even if the columns you want to AutoFilter on are NOT locked...).
See this site for what it is supposed to do in Excel 2002 - "http://support.microsoft.com/default.aspx?scid=kb;EN-US;q289269"
I'll appreciate the help...
Essentially, I need to protect a sheet, but allow AutoFilter to be used for viewing purposes. In Excel 97 this is not permitted (even if the columns you want to AutoFilter on are NOT locked...).
See this site for what it is supposed to do in Excel 2002 - "http://support.microsoft.com/default.aspx?scid=kb;EN-US;q289269"
I'll appreciate the help...