Hi!

I have certain instances of Excel-Sheets with VBA code. I update the
code frequently and have to go through all the Excel sheets and copy and
paste the updates.

Is there a way to store the code centrally and have the sheets update
automatically?

Best regards,
Martin

If all the sheets are in one workbook and the code is same for each sheet,
place the code in Thisworkbook module.

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

your code here

End Sub

If sheets in multiple workbooks see Chip Pearson's site.

http://www.cpearson.com/excel/vbe.aspx


Gord Dibben MS Excel MVP

On Wed, 19 Aug 2009 14:22:53 +0200, Martin Schneider
wrote:

Hi!

I have certain instances of Excel-Sheets with VBA code. I update the
code frequently and have to go through all the Excel sheets and copy and
paste the updates.

Is there a way to store the code centrally and have the sheets update
automatically?

Best regards,
Martin

Gord Dibben schrieb:
If sheets in multiple workbooks see Chip Pearson's site.

http://www.cpearson.com/excel/vbe.aspx

That's it, I guess :-) Thanks and best regards

Martin