J
J.W. Aldridge
Looking for workbook code that runs on each new sheet created.
Columns("A:A").Select
Selection.NumberFormat = "0"
Columns("A:A").Select
Selection.NumberFormat = "0"
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
P
Per Jessen
How is the new sheet created, by code or manually?
D
Don Guillett
activesheet.Columns("A").NumberFormat = "0"
J
J.W. Aldridge
from double clicking on a total in pivot table...
P
Per Jessen
Hi
Insert this in the codesheet for ThisWorkbook.
Private Sub Workbook_NewSheet(ByVal Sh As Object)
sh.Columns("A:A").NumberFormat = "0"
End Sub
Best regards,
Per
Insert this in the codesheet for ThisWorkbook.
Private Sub Workbook_NewSheet(ByVal Sh As Object)
sh.Columns("A:A").NumberFormat = "0"
End Sub
Best regards,
Per
J
J.W. Aldridge
exactly what I was looking for...
couldnt remember the "Sub Workbook_NewSheet" part.
Thanx!
Thanx too Mr. Don!
couldnt remember the "Sub Workbook_NewSheet" part.
Thanx!
Thanx too Mr. Don!