I have a form that managers must complete in the event of an accident and then to be emailed. Currently I have got as far as having code triggered by a command button to email the sheet. I have cells that have validation data and conditionally formatted to reflect data that has been added to that particular cell. The problem is that users can still send the sheet without actually filling in any data, what I am aiming to do is for the command button not to work unless my range of cells has data entered into them.

I have searched high and low but not come up with anything that may work (my vba knowledge is nigh on zero). Can anyone suggest anything that may prevent the sheet from being sent until data has been added to my range of cells?

Many thanks in advance.