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

    Hide Button Code ? (Excel 2002/2003)

    Hi

    I need a little help trying to hide buttons on a sheet.

    Please see my naive attempt in the sheet attached.

    Regards

    Braddy
    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: Hide Button Code ? (Excel 2002/2003)

    You should use the Worksheet_Change event instead of the Worksheet_SelectionChange event.

    Private Sub Worksheet_Change(ByVal Target As Range)
    If Not Intersect(Range("E24"), Target) Is Nothing Then
    Me.CommandButton1.Visible = Not (Range("E24") = "New")
    Me.CommandButton2.Visible = Not (Range("E24") = "Renewed")
    End If
    End Sub

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

    Re: Hide Button Code ? (Excel 2002/2003)

    Hi Hans

    Thank you so much.

    Braddy

    Just a little thing not related to the above, I have the word fix on the right hand side of the status bar what does this mean?
    If you are a fool at forty, you will always be a fool

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

    Re: Hide Button Code ? (Excel 2002/2003)

    You have set "fixed decimal" for data entry. Try entering 314 in a cell. It'll probably be converted to 3.14 when you press Enter or Tab.
    It is a setting in the Edit tab of Tools | Options. Clear the "Fixed decimal" check box if you don't want to use this option.

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

    Re: Hide Button Code ? (Excel 2002/2003)

    HI Hans

    Thanks very much for that


    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
  •