Bloomberg Short Cuts in EXCEL

Question

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.

Answer 1

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

Answer 2

Go to the Bloomberg tab in the workbook, select Options -> Hot Key Manager and disable Bloomberg hotkey (top right corner)