Hide intermediate result

I want to use a checkbox to control the visibility of an intermediate result. In the past I've used conditional formatting but I don't think it's possible this time. I still want the numbers to be present in the given cells - I just want to be able to control whether the user can see them and to be able to use a control such as the checkbox to reveal the intermediate result or to keep it hidden. Ideally, I'd also like to be able to avoid a recalculate if at all possible. Any suggestions?

TIA
Neil

We would need more details (maybe even attach a .zip sample of your workbook) so that we can help you here.

You could use conditional formatting to change the font color to white. That's not completely hidden, but it won't jump out at a glance.

Actually, you're right - I can use the conditonal formatting - just use the "Formula is" =NOT(cell reference for flag set by checkbox). This still forces a recalculate though as my numbers are generated using =randbetween(0, N) - is there a way to prevent certain cells from updating? I know that I can go to Tools..Options..Calculation...and set Manual - (never tried that though) but is there a way to set the manual or automatic mode by calls made from a macro that is kicked off by the checkbox change?

is there a way to set the manual or automatic mode by calls made from a macro that is kicked off by the checkbox change?

Yes, but how depends on the type of checkbox (Forms vs Control Toolbox).

Please Login or Register  to view this content.