Barry, I've never hidden a row but I think it's just a matter of setting the row's Height to 0 (and, of course, of restoring its height to something when the box is unchecked). You should be able to confirm this easily: Just record a macro and hide the row manually, then examine the macro that is created. If that doesn't work as expected, let me know what it did do and maybe I can help you figure it out. (Hint: Almost all novices say simply "that didn't work". That's why I specified "let me know what it did do" :-).) Also, let me know if you don't know how to record a macro, or examine it afterward, and I'll walk you through it.