Excel 2000 AutoFilter and Worksheet protection

[Guest]

Hi, I am trying to use the VBA code given on the Microsoft website at
http://office.microsoft.com/en-us/assistance/HA010982701033.aspx but cannot
get the code to work after several attempts. Does anybody else have any idea
on the code to use in Excel 2000 ?

 

[Tom Ogilvy]

If you name the procedure

Private Sub Workbook_Open()

as shown and place it in the ThisWorkbook module (as described), then when
you open the workbook without disabling macros, the code will run and allow
you to set filter criteria in a protected worksheet (the sheet with a
codename of Sheet1 in the example).

The catch is that the autofilter dropdowns must already be visible. To the
best of my recollection, this does not let you apply an autofilter from
scratch so to speak.

 

[K Dales]

I don't have a solution, but I can verify you that the
code given on the listed page does not seem to work in
Excel 2000 (unless there are some settings I am
overlooking).

-----Original Message-----
Hi, I am trying to use the VBA code given on the Microsoft website at
http://office.microsoft.com/en-

us/assistance/HA010982701033.aspx but cannot