Once you have selected that option from the drop-down menu for the file type, just click Save. Then you want to change the file type to be an Excel Macro-Enabled Workbook (.xlsm). When you go to save your workbook, you may receive this prompt, asking you if you want to ignore the code and save it as a macro-free workbook. Saving Your Workbook as a Macro-Enabled FileĪny time you are placing a macro into an Excel file that doesn't already have them, it's important that you save the file as a macro-enabled workbook (.xlsm). That's where you are going to paste the code that you copied in Step 1. Once the module is added, you can double-click on that new Module1 project to open the code pane if it isn't already open.(The keyboard shortcut to do this is ALT+ I+ M.) Then, if there is not already a code module listed under that sheet, you can insert one by choosing the Insert option, and then Module. In the Project Pane of the VB Editor, select the workbook you want the code to be in.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |