View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
mikeolson mikeolson is offline
external usenet poster
 
Posts: 43
Default 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