Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Objective: When I delete a row on one sheet, I want to delete that same row
on two Other sheets. I don't believe the "Worksheet_Change" handler will work unless there was some way to test if a row was deleted... I was wondering if there was a way to create custom event handlers (i.e. BeforeRowDelete). Psuedo code would look something like: Private Sub Worksheet_BeforeRowDelete(Blah Blah Blah...) myRow = ActiveCell.Row Sheets("Some Sheet").Rows(myRow).Delete Sheets("Some other Sheet").Rows(myRow).Delete End sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Event handler | Excel Programming | |||
API calls, an Event handler, custom menu bar and modal | Excel Programming | |||
Global event handler?? | Excel Programming | |||
where is the workbook_open event handler??? | Excel Programming | |||
Cell Event Handler | Excel Programming |