Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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!! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using NULL in shading cells | Excel Worksheet Functions | |||
Failed to save table attributes of (null) into (null). | Excel Discussion (Misc queries) | |||
NULL Cells | Excel Worksheet Functions | |||
prevent display of data series dropping to graph x axis for null d | Charts and Charting in Excel | |||
Cells().value is null but I can see data | Excel Programming |