Results 1 to 3 of 3
  1. #1
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Help with Formula please (Excel 2002/2003)

    Hi

    What I would like to do, if the cell named Channel3 contains no text then hide sheet Taski. The cell Channel3 contains data validation, if nothing is selected Taski sheet should be hidden


    Sub Taskiview()
    if Channel3"<>" then
    worksheet("Taski").xlVeryHidden
    End if

    End Sub
    If you are a fool at forty, you will always be a fool

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Help with Formula please (Excel 2002/2003)

    1) You cannot refer to a cell this way.
    2) The quotes are placed incorrectly.
    3) It's Worksheets(...), not Worksheet(...)
    4) xlVeryHidden is not a property of a sheet.

    Try

    If Range("Channel3") <> "" Then
    Worksheets("Taski").Visible = xlSheetVeryHidden
    Else
    Worksheets("Taski").Visible = xlSheetVisible
    End If

    (I thought it was ITV instead of Channel3? <img src=/S/innocent.gif border=0 alt=innocent width=20 height=20>)

  3. #3
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Re: Help with Formula please (Excel 2002/2003)

    HI Hans

    Thanks for that, sorry it took so long to reply, I was eating my tea in front of the tele watching ITV <img src=/S/grin.gif border=0 alt=grin width=15 height=15>

    The formula works fine thanks again.

    Braddy
    If you are a fool at forty, you will always be a fool

Posting Permissions

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