Short cut keys in Excel


Julian Brotherton

On the MS web site I found this statement:-
Note The shortcut key will override any equivalent default Microsoft Excel
shortcut keys while the workbook that contains the macro is open.

This is not the case. when I assign a short cut key of ctrl b and try
running the assigned macro all i get is a "bling" noise from the computer.
The macro doesn't run


Make sure you are not in design mode and close any open dialog boxes. The
Microsoft warning is correct. If you assign the macro to a key normally used
for another purpose, your assignment will override the normally assigned
function while in that workbook. Also, the assignment is case sensitive. If
you assigned Uppercase B and try to use lowercase b then you will probably
get the bling.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question