I know that you can remove the green flags so that you cannot see them by changing "tools>options>error checking>unticking enable error checking in background", but I am looking for a way to 'Ignore Error' on all cells at once that have a Green flag so that when another user on a different PC opens the workbook they will not see the green flags even if "enable error checking in background" is checked on their version of Excel. (I am on Windows 7 using Excel 2010)