Since the macro is contained with the workbook it was created within, if the workbook is sent to another Excel user or placed on a network drive, the macro will be there as well and other users can use that macro when that workbook is open on their system.įiles that contain a macro or VBA code must be saved as a. By storing the macro in the active workbook, the macro can be used within the that workbook or if that workbook is open. The “THIS WORKBOOK” option will create a module within the active workbook where Excel will save the macro (VBA Code). This option ultimately determines not only where the macro will be saved, but also where you can access the macro and where it can be used. A lot of Excel users get confused when they are recording an Excel Macro and they get prompted where they want to store their Excel Macro in?ĭuring the initial setup of recording a macro a prompt will present itself asking where the macro should be stored.
0 Comments
Leave a Reply. |