userform error 1004 select method of range class failed
I get this error when I click this button. It always worked before I changed
the .visible class of inactive sheets to false 'xlsheetveryhidden. the only
visible sheet is the active sheet. This button is on Sheets("F"), I click
the button and it places a value in sheet MAIN and breaks on
formRowsource.show. I'm guessing it has to do with the inactive sheets being
hidden, but I can't figure it out. Please help.
Private Sub CommandButton1_Click()
ThisWorkbook.Unprotect
Sheets("MAIN").Range("AB5") = "L"
formRowsource.Show
End Sub
Thanks!
Mike
|