Archived discussions are read-only. Learn more about SAP Q&A

How to trigger a VBA Macro?


I intend to use a Macro to format my workbook. I have created a macro by name "Format" now I wrote the name in the "Exits" tab of "Workbook Settings" and clicked "Attach Macro" and clicked "OK". Then I saved the workbook. Now when I reopen the workbook and refresh the workbook query there is no effect of the Macro.

Please suggest how I can make this macro work.

The code I have is:


Sub Format(<b>Technical Name of Query</b>, )


' Format Macro

' Macro recorded 2/5/2007 by Registered User



Columns("F:F").ColumnWidth = 7

End Sub




Not what you were looking for? View more on this topic or Ask a question