Home |
Search |
Today's Posts |
#1
|
|||
|
|||
enable autofilter in a protected worksheet in Excel 97
I have found ways to enable autofilter on a protected worksheet for Excel
2000, '02 and '03. However, my company doesn't believe in upgrading very often. I really need to protect my worksheets, but leave the autofilter functionable. Any ideas??? |
#2
|
|||
|
|||
The Workbook_Open code shown here will work in Excel 97:
http://www.contextures.com/xlautofilter03.html#Protect Ensure that the filter is in place before the sheet is protected. WooGHeR wrote: I have found ways to enable autofilter on a protected worksheet for Excel 2000, '02 and '03. However, my company doesn't believe in upgrading very often. I really need to protect my worksheets, but leave the autofilter functionable. Any ideas??? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Question about sorting in protected worksheet | Excel Worksheet Functions | |||
How to change the tab order for a protected worksheet | Excel Worksheet Functions | |||
How do i delete a row in a excel worksheet that is protected | Excel Worksheet Functions | |||
How to enable font color on protected worksheet? | Excel Discussion (Misc queries) | |||
How use group and ungroup functions while worksheet is protected | Excel Worksheet Functions |