I have a great little WB here that Ragonzo helped me with originally building.
Here are the two enhancements I need:
1.) If I want the "confidential" text to show up on Sheets 2 and 3, but want it to show up and disappear (depending on the status of the checkmark -- on/off) how do I distinguish between the cells? Right now, it shows up at the same sell on each Sheet.
2.) If I want to simply say "all sheets" so as not to have to identify each individual sheet, what line of code would I use to substitute where it tells which sheets to place the text?
Thank you in advance.