Blank Cells should be updated [Closed]

Report
-
Posts
1021
Registration date
Saturday May 23, 2009
Status
Contributor
Last seen
October 20, 2010
-
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 reply

Posts
1021
Registration date
Saturday May 23, 2009
Status
Contributor
Last seen
October 20, 2010
182
Have a read here.

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

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!