You access the VBA code using the Visual Basic Editor window. ![]() Personal Macro Workbook - Storing your macros here will mean that they are available every time Excel is open and are not reliant on any one particular workbook. This can be useful for quickly examining the generated code but remember that the workbook you store the macro in must be open in order for the macro to be run. New Workbook - A completely new workbook will be opened for you automatically. The currently active workbook is also referred to as the current workbook or active workbook. A macro that has been saved into a specific workbook is only available when that particular workbook is open. ![]() This Workbook - This is the default location and is often the best place if you are relatively new to macros. ![]() There are three possible workbooks where you can save your macros:
0 Comments
Leave a Reply. |