I have a spreadsheet which is a Shared workbook. As this tracks the history of what happens to the spreasheet, If someone tries to deselect it I want a message to appear to with a YES and NO option button, so if they have not copied the history data the shared workbook remains, if they have copied the data and then click yes the shared workbook then becomes unticked and therfore exclusive...any ideas ?