If you do select an existing Excel key combination, this will be overwritten by your macro, and you, or other users, may end up accidentally executing your macro code. However, you should be careful not to assign one of Excel's predefined key combinations (e.g. ![]() This will make the macro much easier to run. The 'Record Macro' dialog box also gives you the option of assigning a keyboard shortcut to your macro. ![]() However, if you do not supply a name, Excel will automatically assign a macro name (e.g. It is a good idea to give the macro a meaningful name, so that when you come back to the macro at a later date, this will help you to remember what it does. ![]() This box allow you to enter a name and description for your macro if you wish. You will then be presented with the 'Record Macro' dialog box shown on the right above.
0 Comments
Leave a Reply. |