Conditional Saving

[VISHNAN]

I have a excel file that has the variance between Budget and Actual sales for each quarter. Users are required to quantify each reason for the variance for each quarter and 6 rows are provided for each type of comment. The 7th row is called" Misc" which balances the rest of the unanswered variance. Hence the final total of all the explanations will ultimately be equal to the variance. The users should not be able to save the file until the whole exercise is complete ,meaning that the variances are fully bridged for each quarter. Besides in order to prevent users from using the "Misc" to get away with unexplained reasons, I would like to ensure that the "Misc" is not more than 5% of the total variance. Can someone assist me with the necessary VBA in excel?

[6StringJazzer]

Here's a start. You need to put the following code into the module for ThisWorkbook. You haven't described your data layout so I can't be more specific than this. If you need further help it would be a good idea to attach your file.

Please Login or Register  to view this content.