workbook_sheetchange
 

where do i put code using the workbook_sheetchange event ... what i'm trying
to do, is update a column on a sheet when anything on the summary sheet
changes.

thanks
JulieD

workbook_sheetchange
 

Try right-clicking on the Excel icon
(just to the left of "File" on the menu)

Choose "View Code"

In VBE, select "SheetChange" from the right droplist
(or just paste the code in the whitespace there
after clearing the defaults)
--
Rgds
Max
xl 97
---
Please respond in thread
xdemechanik <atyahoo<dotcom
----
"JulieD" wrote in message
...
where do i put code using the workbook_sheetchange event ... what i'm
trying
to do, is update a column on a sheet when anything on the summary sheet
changes.

thanks
JulieD