workbook_sheetchange

J

JulieD

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
 
M

Max

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)
 
Top