Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Execute Macro When any Built-in Autofilter Button is Pushed
Excel 2003: Is anyone aware of a procedure to execute a macro when any drop
down button in an autofiltered list is pushed? Specifically, I have locked all cells in a database range on a worksheet, applied an autofilter to the database range, and protected the worksheet. Upon pushing the built-in autofilter button near each field name, the protected database filters correctly, but will not sort when the 'Sort Ascending' or 'Sort Decending' choices are selected. I'd like to automatically unprotect the sheet temporarily when an autofilter button is pushed - so that a sort can occur - and then re-protect the sheet when the sort is finished. -- Thanks, Jay |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
change/set pivot table autofilter criteria with macro button | Excel Discussion (Misc queries) | |||
Cells turn 'hot' and execute distant macro button | Excel Discussion (Misc queries) | |||
Macro won't execute from a Command Button | Excel Programming | |||
Returning last button pushed in Excel 7 | Excel Programming | |||
button to execute macro | Excel Programming |