View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Alan[_2_] Alan[_2_] is offline
external usenet poster
 
Posts: 116
Default userform error 1004 select method of range class failed

I replicated your code, using Sheets("Main") as a xlSheetVeryHidden
worksheet, and a Sheet("F") as the active visible worksheet. I did not
receive any errors writing to or extracting from the xlSheetVeryHidden
worksheet.

Regards,

Alan


"mikeolson" wrote in message
...
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