Short cut keys in Excel


J

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
 
Ad

Advertisements

J

JLGWhiz

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

Top