![]() It will be there when you save it and reopen again, or even if you share it with someone. This step ensures that the macro is a part of the workbook. In the ‘Store macro in’ option, make sure ‘This Workbook’ is selected.For example, if you assign the shortcut Control + S, you will not be able to use this for saving the workbook (instead, everytime you use it, it will execute the macro). Remember that the shortcut you assign here would override any existing shorcuts in your workbook. In this case, we will use the shortcut Control + Shift + N. (Optional Step) You can assign a keyboard shortcut if you want.You can also use underscore to separate two words – such as Enter_Text. I usually prefer to keep my macro names as a single word, with different parts with a capitalized first alphabet. For example, you can not use spaces in between. There are some naming conditions that you need to follow when naming a macro. In the Record Macro dialog box, enter a name for your macro.This will open the ‘Record Macro’ dialog box. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |