workbook code - new sheet created...

  • Thread starter Thread starter J.W. Aldridge
  • Start date Start date
J

J.W. Aldridge

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

Columns("A:A").Select
Selection.NumberFormat = "0"
 
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
 
exactly what I was looking for...

couldnt remember the "Sub Workbook_NewSheet" part.

Thanx!
Thanx too Mr. Don!
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Looping through columns 2
Macro Paste Problem 0
Run-time error 9 (Subscript out of range) 3
Save each sheet of multi-sheet workbook as a single-sheet workbook 3
Deleting columns on multiple sheets 4
Excel How to run multiple Private Sub Worksheet_Change(ByVal Target As Range) 0
VBA code for pasting links -- modifying RDB code for summary workbook 10
paste named range on each sheet created 6

Back
Top