Thread
:
Cell data required upon close
View Single Post
#
3
Posted to microsoft.public.excel.programming
pjhageman[_13_]
external usenet poster
Posts: 1
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 With Quote
pjhageman[_13_]
View Public Profile
Find all posts by pjhageman[_13_]