My file have many sheet
If user save file or save as anytime
1.Let it check sheet 1 ,sheet2,sheet3,sheet 4,sheet5,sheet6 ..sheet's name
(1),(2),(3),(4),(5),(6)
in cell (a3) of each sheets. if cell (a3) have value (must have 2 sheets up only ) and also check the sheet(TOTAL) cell (a6)
if cell (a6) no value . then massage box, " the file not be save until user have run macro1 " , if user run macro1 already . the file will save .
2.If cell (a3) of each sheets have value (must have 2 sheets up only ) and sheet(TOTAL) cell (a6) have value . the file will save .
3.If cell (a3) of each sheets, have value only 1 sheets and check the sheet(TOTAL) cell (a6) have no value . the file will save .
4.If cell (a3) have no value in each 6 sheets and check sheet(TOTAL)
cell (a6) no value . the file will save .
thank
Bookmarks