Looking for workbook code that runs on each new sheet created.

Columns("A:A").Select
Selection.NumberFormat = "0"

How is the new sheet created, by code or manually?

---
Per

On 1 Maj, 21:28, "J.W. Aldridge" wrote:
Looking for workbook code that runs on each new sheet created.

* * Columns("A:A").Select
* * Selection.NumberFormat = "0"

activesheet.Columns("A").NumberFormat = "0"

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"J.W. Aldridge" wrote in message
...
Looking for workbook code that runs on each new sheet created.

Columns("A:A").Select
Selection.NumberFormat = "0"

from double clicking on a total in pivot table...

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

On 1 Maj, 22:06, "J.W. Aldridge" wrote:
from double clicking on a total in pivot table...

exactly what I was looking for...

couldnt remember the "Sub Workbook_NewSheet" part.

Thanx!
Thanx too Mr. Don!