Thank you guys for all your patience. Sorry the protection was on but there isn't a password on it. The macro works marvellous and I've removed the original macros in the workbook/sheets.

Thank you Thank you