Search code examples
excelbloomberg

Bloomberg Short Cuts in EXCEL

Is there a method to remove or at least disable Bloomberg keyboard short cuts in Excel?

For example, normally to open a filter I can press CONTROL + SHIFT + L. However, this shortcut is now being used in Bloomberg and it causes my Excel to either freeze or not load for some time.

Solution

  • Run the following code in VBA:

    Public Sub DisableBloomberg()    
    Application.OnKey "+^l"    
End Sub

    This should disable them, if you are lucky :) Here you can read more about Application.OnKey.

    If you do not know what VBA is, then in Excel do the following:

    1. Press Alt+F11
    2. Press Ctrl+G
    3. Write Application.OnKey "+^l" to the opened window and press Enter