Changing build-in keyboard shortcut?

[z3115]

My company uses a set of macros with assigned shortcuts. One of them is Ctrl+Shift+L, which overwrites the default Ctrl+Shift+L shortcut that filter the current selection.

For consistency's sake I want to leave the macro shortcut unchanged, but is there a way to assign a new keyboard shortcut to the Filter function? Thanks!

 

[offthelip]

yes you can do this by writing a macro as below and then assigning it to the key of your choice.

Sub Mfilter
Selection.AutoFilter
end sub