Error 1004 - 'select method of worksheet class failed'

Thanks Thanks:  0
Likes Likes:  0
Results 1 to 7 of 7

Thread: Error 1004 - 'select method of worksheet class failed'

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    34
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    Can anyone tell me why this code produces the error message above?

    Sheets("Data").Select
    Rows("2:2").Select
    Selection.copy
    Sheets("Hist").Unprotect

    ---this row causes problems -----
    If Worksheets("Hist").Visible = True Then Sheets("Hist").Visible = True
    ---------------------------------
    Sheets("Hist").Select
    Range("A1").End(xlDown).Offset(1, 0).Select
    Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _
    False, Transpose:=False
    Application.CutCopyMode = False
    ActiveWorkbook.Save
    Sheets("Hist").Visible = False

    That part of it I recorded cos I,ve started having problems with it, and it worked ok twicw and now I have problems with it again. This is the only thing stopping a nice app from working!

    Thanks

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Sunny, spring-like Hull
    Posts
    3,339
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    does : -

    If Worksheets("Hist").Visible = False Then Sheets("Hist").Visible = True
    Sheets("Hist").Select

    work OK?

  3. #3
    New Member
    Join Date
    Mar 2002
    Posts
    34
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    It used to... about an hour ago. Then stopped and I get the 1004 now. I don't get it - I recorded that bit!


  4. #4
    New Member
    Join Date
    Mar 2002
    Posts
    34
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Doh! I realised the mistake as I hit the Submit button! Ok - so that bit's ok, now I get the 1004 on the last bit -

    Sheets("Hist").Visible = True

    but it says - Unable to set the Visible property on the Worksheet class.
    Am I missing something here?

    [ This Message was edited by: matthewh on 2002-05-29 05:46 ]

  5. #5
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Sunny, spring-like Hull
    Posts
    3,339
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Is your workbook protected? If so, i think you'll have to unprotect it first.

  6. #6
    New Member
    Join Date
    Mar 2002
    Posts
    34
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    It unprotects it a couple of lines above that, then re-protects it. It's a history of some transactions that I can't have people changing.

  7. #7
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Sunny, spring-like Hull
    Posts
    3,339
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    You're unprotecting your worksheet there, but is your actual workbook protected, as this can prevent your sheets from being hidden and unhidden?

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com