Im looking for a way to call a module from an open event that will go thru each worksheet of a workbook and auto fit all of the columns. If anyone can hook me up with some code it would be greatly appreciated. Thanks!
Im looking for a way to call a module from an open event that will go thru each worksheet of a workbook and auto fit all of the columns. If anyone can hook me up with some code it would be greatly appreciated. Thanks!
Greetings John,
In a Standard Module:
[vba]
Sub FitCols()
Dim wks As Worksheet
For Each wks In ThisWorkbook.Worksheets
wks.Columns.AutoFit
Next
End Sub
[/vba]
Hope that helps,
Mark