Phil,

We have had this question in various forms on a number of occasions over the
past week, and have tried various answers.

I gave a response previously that checked those same cells on exiting the
sheet, including a workbook close code. Are you still have problems with
that, if so I offered to look at the workbook for you.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Phil Hageman" wrote in message
...
I need a Sub preventing users from saving a workbook, when
on worksheet "Scorecard" certain cells (cell ranges with
percent values) are blank:
G26:I26 Customer Weight
AG26:AI26 L&G Weight
G44:I44, Financial Weight
AG44:AI44 Process Weight

Also need a message box directing the user to the blank
cell, saying which cells are blank: "A value greater than
zero is required for Customer Weight." If more than one
cell is blank, the message would include those cells too.

Where would I put the Code?

Thanks, Phil