I have a workbook with 3 sheets, Budget, Extract and Summary where Summary
contains a Pivot Table which is macro generated from data in the Budget and
Extract sheets.

I've got macro buttons (auto-shapes) on the 3 sheets and I want to add macro
buttons to the new sheet which is generated when a cell is double-clicked in
a pivot table (to show the detail behind the summary).

These sheets will always be called Sheet1, Sheet2 etc.

Is it possible to run a macro automatically each time a new worksheet which
begins with "Sheet" is generated? If so, how do I do this please as I'm stuck?

Thanks a lot in anticipation.

In the VBE, find the "ThisWorkbook" object, then in the left combobox, select
"Workbook", in the right combobox select "NewSheet". This should add a
routine that looks like this:
Private Sub Workbook_NewSheet(ByVal Sh As Object)

End Sub

change it to look like this:
Private Sub Workbook_NewSheet(ByVal Sh As Object)
Call YourMacro
End Sub

This will run the macro named "YourMacro" everytime a sheet is added to your
workbook
--
Charles Chickering

"A good example is twice the value of good advice."


"nospaminlich" wrote:

> I have a workbook with 3 sheets, Budget, Extract and Summary where Summary
> contains a Pivot Table which is macro generated from data in the Budget and
> Extract sheets.
>
> I've got macro buttons (auto-shapes) on the 3 sheets and I want to add macro
> buttons to the new sheet which is generated when a cell is double-clicked in
> a pivot table (to show the detail behind the summary).
>
> These sheets will always be called Sheet1, Sheet2 etc.
>
> Is it possible to run a macro automatically each time a new worksheet which
> begins with "Sheet" is generated? If so, how do I do this please as I'm stuck?
>
> Thanks a lot in anticipation.

Many thanks Charles - that's excellent.

Thanks again