Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2000 AutoFilter and Worksheet protection
Hi, I am trying to use the VBA code given on the Microsoft website at
http://office.microsoft.com/en-us/as...982701033.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 ? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2000 AutoFilter and Worksheet protection
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. -- Regards, Tom Ogilvy "Phillo" wrote in message ... Hi, I am trying to use the VBA code given on the Microsoft website at http://office.microsoft.com/en-us/as...982701033.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 ? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2000 AutoFilter and Worksheet protection
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 get the code to work after several attempts. Does anybody else have any idea on the code to use in Excel 2000 ? . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2000 - Autofilter Limit | Excel Worksheet Functions | |||
EXCEL PROTECTION 2000 | Excel Discussion (Misc queries) | |||
2003 Shared Worksheet Protection Settings Failing For My 2000 User | Excel Worksheet Functions | |||
How to Sort within AutoFilter with Protection on (and AutoFilter . | Excel Discussion (Misc queries) | |||
Using AutoFilter with worksheet protection in 2000 vs. 2003 | Excel Discussion (Misc queries) |