Re: $$Excel-Macros$$ User form + Macro to activate certain region of active work sheet.

again you should use ratio buttion on this Please find attached solution Regards Santosh Bahuguna On Tue, Jun 28, 2011 at 11:53 PM, Rash wrote: > Hi all, > > Need Help... > > I have a user form in which i have 6 check boxes. ok and cancel button. > > when ever I click 1st check box, rows 1 to

Re: $$Excel-Macros$$ User form + Macro to activate certain region of active work sheet.

Dim ws As Worksheet Const pass As String = "rash" Dim ArChkBox(1 To 6) As Object Private Sub UserForm_Activate() Set ArChkBox(1) = CheckBox1 Set ArChkBox(2) = CheckBox2 Set ArChkBox(3) = CheckBox3 Set ArChkBox(4) = CheckBox4 Set ArChkBox(5) = CheckBox5 Set ArChkBox(6) = CheckBox6

$$Excel-Macros$$ User form + Macro to activate certain region of active work sheet.

Hi all, Need Help... I have a user form in which i have 6 check boxes. ok and cancel button. when ever I click 1st check box, rows 1 to 10 should to be editable, rest all rows should be non editable and hidden. For check box 2, rows 11 to 20 editable, rest up and down area should be non edita