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
|