Blank Cells should be updated

Closed
Vinod Kumar - Dec 15, 2009 at 08:54 AM
sharpman Posts 1021 Registration date Saturday May 23, 2009 Status Contributor Last seen October 20, 2010 - Dec 15, 2009 at 05:46 PM
Hello All,

I need an Excel Formula that should not allow the user to save a excel file until the information been updated in the cells.
For example: From ("B2:B22") all information need to update if one cell has blank it should through a pop-up message and also the save button need to be disable untill all the infromation provide.

Thanks inadvance.

"Happy Christmas & Happy New year"

Regards,
Vinod

1 response

sharpman Posts 1021 Registration date Saturday May 23, 2009 Status Contributor Last seen October 20, 2010 183
Dec 15, 2009 at 05:46 PM
Have a read here.

http://en.allexperts.com/q/Excel-1059/Disable-save-command-condition.htm
0