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
 
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

Similar Threads

VBA word change keys 0
I have nearly run out of Shortcut Keys 4
Disable Cut/Copy/Paste in Excel 2010 0
short cut keys work- run macro does not 2
Excel 2007 Custom ShortCut Keys 1
Assign short-cut key to existing macro 1
Assigning Short-Cut Keys 1
Ligit macro assignment keys 1

Top