Sadly, you can't trap the deletion or the hiding/unhiding of a row or
column.

--

Vasant

"Alan" wrote in message
...

Hi All,

I have a need to trap two events that I cannot see how to achieve in
Excel 2000.

1) Delete (entire) row event.

This does trigger the worksheet_change event but I need to return the
specific row (or rows) that were deleted and know that it was deleted
(rather than just changed).

The target value will tell me the cell (and hence row) that was
changed, but how do I know whether it was actually deleted or just
changed?

Of course, after being deleted, the row still exists, albeit a new row
that was previous below the deleted row.



2) How can I identify when a column (or range of columns) has been
hidden or unhidden?

This does not seem to trigger the worksheet_change event or any other
that I can determine?


Thanks,

Alan.