It's always a struggle to word title properly! Here is my problem. I have a workbook with many sheets, but there are 3 cells on on each of four sheets (thus 3 cells x 4 sheets = 12)which are posing this problem. On a 5th sheet is a group of cells and check boxes. If A1 on sheet1 is checked (this selection is also mirrored on sheets2,3 and 4), then I have CF that hides this info on sheet5 using white. Then if I remove the check from sheet1(A1) and put it in sheet1(A2 or A3), then I want what's on sheet5 to display. This works well if tied only to sheet1, but it I try and tie in the other three sheets it just does not work, such as changing sheet3(A1) to A3! I got very close, but I also have cells on sheet 5 that are yellow if empty and it's this I cannot seem to hide! So, I thought I would record a macro and try that, and by using an "IF" statement got close, got the stuff on sheet5 to hide, but then I could not get it to unhide. I hope I explained my predicament clear enough and hope there is a fairly simple way of making this work. Thanks for reading this long winded problem!
Bookmarks