I'd just use a formula in a prominent location--giant letters in Red.

=if(something is ok,"","Please fix this yourdescriptionhere")

And to add to Earl's response. If the user opens the workbook and decides that
they opened the wrong workbook (or just want to close without saving), you'll
have to give them a way to do it.

Adam Harding wrote:

I am redesigning my budget form to incorporate two sheets, one is a detailed
sheet by nominal code in cost centre for budgets over the next 5 years by
month. The other is a supplier listing with annual budgets against them.

I want to prevent users saving or closing-down the sheet unless the total of
the suppliers budgets = total of the nominal budgets for the year. Simply
unless cell K9 is 0.00 then prevent closing of the form. Please help as this
will save me LOADS of time when it comes to checking these things.

Many thanks in advance

Adam

--

Dave Peterson