disable buttons on a form based on an active sheet

[Eddie G.]

when i activate a form, i want certain buttons on that form to become disabled depending on what sheet is active. so for example, if sheet 1 is active, i want checkbox2 and checkbox3 to become disabled when the form is opened. help.....

[Mark O'Brien]

Something like this would work:

  If ActiveSheet.Name = "Sheet1" Then

    Me.CheckBox1.Enabled = False

    Me.CheckBox2.Enabled = False

  End If

Put this on your userform, I put it in my "Initialize" event.

If you are going to use a lot of different sheets, I would suggest using Select...Case instead of If...Then.

e.g.

  Select Case ActiveSheet.Name

  

  Case "Sheet1"

    Me.CheckBox1.Enabled = False

    Me.CheckBox2.Enabled = False

  

  Case "Sheet2"

    Me.CheckBox3.Enabled = False

    Me.CheckBox2.Enabled = False

  

  Case Else

    'do nothing

  End Select

HTH