View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Darren Hill[_3_] Darren Hill[_3_] is offline
external usenet poster
 
Posts: 68
Default macro to write other macros?

I have the following simple macro:

Private Sub Worksheet_Change(ByVal Target As Range)

If Not Application.Intersect(Range("Conditions"), Target) Is Nothing Then
Call FormatConditions(Target)
End If
End Sub

Is it possible to write a macro that adds this to the code module of all
worksheets?


Darren