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