View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Fabricio Fabricio is offline
external usenet poster
 
Posts: 9
Default Does Excel have a SheetBeforeChange Event?

I'm looking for a workbook (or worksheet) event that gets triggered before
Excel changes the worksheet. The SheetChange event gets triggered after the
changes have been made to the worksheet--too late for me :)

I'm trying to mimic the response a user gets when she tries to modify a
single cell in an array formula. Excel replies with a message box "You
cannot change part of an array." and does not allow her to make changes.

Thanks in advance,
-Fabricio