Max

I thought about later last night and realized I had posted code for just one
worksheet and OP wanted all worksheets.

Was going to re-post this morning so here goes.

Enter this in the Thisworkbook module not in a sheet module.

Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
'enter event code here
End Sub

Will cover all sheets.


Gord

On Tue, 29 Aug 2006 02:05:02 -0700, Max wrote:

Hi Gord, just a little side-track here ..

.. This is sheet event code.
Right-click on the sheet tab and "View Code"
Copy/paste the above into that sheet module

Is there code which can auto-apply the sheet event code
into every sheet in the book ?

Gord Dibben MS Excel MVP