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

How to trigger a VBA Macro?

Hi,

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

__________________________________________________________

Thanks

Kumar

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