Short cut keys in Excel

  • Thread starter Thread starter Julian Brotherton
  • Start date Start date
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
 
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

I have nearly run out of Shortcut Keys 4
Assign short-cut key to existing macro 1
short cut keys work- run macro does not 2
Assigning Short-Cut Keys 1
Button Click but not Shortcut Key 1
Excel 2007 - Macro Shortcut Key Doesn't Work 3
Assign macro to shortcut keys "ctrl + 1"? 2
Ctrl Shift | Macro Stops | Creating Short Cut Keys 3

Back
Top