Adding macro to worksheet

[angiem]

I have a worksheet that when a button is selected creates a new worksheet. Then when the user changes a value on the new worksheet it retotals the columns. I know I can use the worksheet_change to achieve this, just don't know how to program it to do it on each new worksheet. Any ideas?

 

[DrBowes]

Use the workbook_sheetchange event:

Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)

You can limit the events to certain sheets with conditional statements on Sh.Name.

 

[angiem]

Thanks, worked a treat!!