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!! |
Using worksheet_selectionchange to prevent null cells ???
Use the deactivate event
http://www.cpearson.com/excel/events.htm Chip Pearson's page on events. -- Regards, Tom Ogilvy "Spyder" wrote in message ... 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!! |
All times are GMT +1. The time now is 02:19 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com