how to make my macro available in all excel workbooks

From the list, select the macro you want to use.In the Caption box, name the button and in the Cell Address box and specify where you want the button to appear.Note: Excel files that contain a space in their filename cannot contain buttons. To enable a macro as a button in a workbook The text editor opens to accept your changes.From the list in the Winshuttle Macro Publisher dialog box, select the macro you want to use.To edit macros already published to workbooks In the Winshuttle Macro Publisher dialog box, click Import.You must manually ensure the VBA syntax is correct. No VBA validation of the macro is possible.The Excel file that you publish to must be macro enabled.Macros created in TRANSACTION can be run in the TRANSACTION and RUNNER clients and in the RUNNER add-in for Excel. You can also edit macros in that are already published to workbooks from within TRANSACTION without opening VBA. In TRANSACTION, you can publish macros in Excel workbooks and customize aspects of the variables. You may have quite a few macros in a file, so you’ll want to give it a descriptive name to easily identify what it does.New features in TRANSACTION version 10.6/10.7 > Running scripts > Publishing macros in an Excel workbook The name must start with a letter and can’t have any spaces, symbols, or punctuation marks. The Record Macro window opens, where you can set up the macro’s name, description, and shortcut keys before you record it. If necessary, turn on the Developer tab.

If you do make a mistake while recording a macro, don’t worry-you can always delete the existing macro and try again or edit the macro’s Visual Basic source code to fix the mistake. Practice or rehearse your script a couple times, to make sure it works, before you actually record it. Before recording a macro, it’s helpful to write down a script that contains all the steps you want the macro to record. When you create a macro, imagine you’re being recorded every step you make is being tracked-all your commands, the data you enter, even any mistakes you make. This lesson explains the easy way to create a macro-by recording the task(s) you want the macro to execute for you. There are two ways to create a macro: by recording them or by writing them in Excel’s Visual Basic programming language.

How to make my macro available in all excel workbooks