B B.M.Srinivasa Sep 28, 2004 #1 How to validate the Cells in MS Excel, so that when the cells are blank the sheet should not save
D David McRitchie Sep 28, 2004 #2 You would need to use Before Save Event Macro and it would have to the checking based on your requirements. http://www.mvps.org/dmcritchie/excel/event.htm HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
You would need to use Before Save Event Macro and it would have to the checking based on your requirements. http://www.mvps.org/dmcritchie/excel/event.htm HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
M Myrna Larson Sep 28, 2004 #3 You need to use a Workbook_BeforeSave event macro that checks each of the cells in question, and if any are blank, sets the Cancel argument to True.
You need to use a Workbook_BeforeSave event macro that checks each of the cells in question, and if any are blank, sets the Cancel argument to True.
