| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
I want alert message when i close xl window if cells in are blank
Please let me know how should i get alert message when i close my excel
window if selected cells are empty. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
I want alert message when i close xl window if cells in are blank
Probably the best way to do this is to put some code in the workbook's
_BeforeClose() event to verify that all required cell entries have been made and to alert you if they haven't and offer to let you cancel the Close action so you can complete the workbook. "Anitha" wrote: Please let me know how should i get alert message when i close my excel window if selected cells are empty. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I skip blank cells when writing formulas | Excel Worksheet Functions | |||
| How to count blank cells that contain formula? | Excel Discussion (Misc queries) | |||
| Automatically add "0" to blank cells without a formula in the cel. | Excel Worksheet Functions | |||
| enter numbers in blank cells | Excel Worksheet Functions | |||
| Blank Cells in Pivot Tables | Excel Discussion (Misc queries) | |||
Hybrid Mode
