Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell data required upon close
User opens a workbook/worksheet with a cell (merged cells, A1:A6) blank
What code would I use to prevent the user from exiting the workshee with the cell blank? A close without saving would be legal. I am using data validation to insure entered values are -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell data required upon close
Have a look in ThisWorkbook module for before_close
-- Don Guillett SalesAid Software "pjhageman " wrote in message ... User opens a workbook/worksheet with a cell (merged cells, A1:A6) blank. What code would I use to prevent the user from exiting the worksheet with the cell blank? A close without saving would be legal. I am using data validation to insure entered values are 0 --- Message posted from http://www.ExcelForum.com/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell data required upon close
Don, Thanks for your reply, but I don't understand it. Phil
Don Guillett wrote: *Have a look in ThisWorkbook module for before_close -- Don Guillett SalesAid Software "pjhageman " wrote in message ... User opens a workbook/worksheet with a cell (merged cells, A1:A6) blank. What code would I use to prevent the user from exiting the worksheet with the cell blank? A close without saving would be legal. I am using data validation to insure entered values are 0 --- Message posted from http://www.ExcelForum.com/ * --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel shoud not close all active books when clicking close button | Excel Discussion (Misc queries) | |||
excel - Windows close button (x) should only close active workboo. | Setting up and Configuration of Excel | |||
Need to put data in a new cell at close of market. | Excel Worksheet Functions | |||
Need to put data in a new cell at close of market. | Excel Worksheet Functions | |||
Change Cell Data of a Required Column | Excel Programming |