View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Spyder Spyder is offline
external usenet poster
 
Posts: 7
Default Using worksheet_selectionchange to prevent null cells ???

Does anyone have an example of code I might use with
"worksheet_selectionchange" to prevent a user of my workbook from leaving
cells null withing a specific range? Note that users may add rows to the
middle of the range, but none of the cells in the added rows withing the
range should be null. Ideal case would result in a pop-up when the user
tried to leave the worksheet.

THANKS FOR ANY DIRECTION!!