Export a Sub to Excel

DasChamaeleon

Hey there.
Maybe I wont get help to my other topic so I just try to find an alternativ solution.
How do I export an VBA-Code to Excel while using the standard funktion (CTRL+E in a List Page) to export to excel.

I would like to export following code:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

Tabelle1.Columns("A:Z").AutoFit

End Sub

Greets

Jan_Veenendaal

The only way I can think of is adding this sub to your default template for Excel - but I'm not sure that will be used when Excel is opened from NAV.

Jan Veenendaal