View Single Post
  #1   Report Post  
Adam Harding
 
Posts: n/a
Default Preventing closedown unless condition is met. HELP

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