I have a workbook that has 9 sheets of data. On 8 of the sheets I want to add a macro button to display or not display a predetermined "Camera" image from the 9th summary sheet.
The image would be a summary of data specific to the sheet the user is on, and that the user can either display or not display. So the button on each sheet would need to display some predetermined data from the summary sheet, data that is only relevant to that sheet.
I hope that makes sense...
The image would be a summary of data specific to the sheet the user is on, and that the user can either display or not display. So the button on each sheet would need to display some predetermined data from the summary sheet, data that is only relevant to that sheet.
I hope that makes sense...
