Reply to thread

Message: [QUOTE="Dave Peterson, post: 6410962"] Just to add... Since this code is behind a worksheet, the unqualified ranges (rows(14:14)) will belong to the sheet that owns the code. And since you can only select a range on the activesheet, your code fails. You could have used: If CheckBox3 = True Then with sheets("Output") .select .rows("14:14").select selection.entirerow.hidden = false end with else... But it's better not to select anything in your code. The resulting code will be much easier to read. I would have used something like: Private Sub checkbox3_Click() workSheets("Output").Rows(14).EntireRow.Hidden = Not (CheckBox3.Value) End Sub [/QUOTE]