View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Arvi Laanemets Arvi Laanemets is offline
external usenet poster
 
Posts: 510
Default Enable autofilter in protected worksheets in Excel 2000

NB! You have to create an Open event for workbook, not some procedure in
standard module!

When you open VBA editor, in VBA Project window locate YourProjectMicrosoft
Excel ObjectsThisWorkbook, right-click on it, and select View Code.
At top of code window are 2 dropdowns - from left one select Workbook, and a
dummy Open event is created. Edit it.


Arvi Laanemets