Hey Thanks Sam It's working..
*
*
*Regards,*
*Jocky*
On Mon, Nov 14, 2011 at 8:30 PM, Sam Mathai Chacko wrote:
> Use this code in Sheet1 VBA code module
>
> Private Sub CommandButton1_Click()
> ActiveSheet.Range("B4:B32").EntireRow.Hidden = Not
> ActiveSheet.Range("B4:B32").EntireRow
Use this code in Sheet1 VBA code module
Private Sub CommandButton1_Click()
ActiveSheet.Range("B4:B32").EntireRow.Hidden = Not
ActiveSheet.Range("B4:B32").EntireRow.Hidden
End Sub
Private Sub CommandButton2_Click()
ActiveSheet.Range("B35:B50").EntireRow.Hidden = Not
ActiveSheet.Range("B35:
HI Team,
I had created one sheet in which i made the Groups Now i want to link
the Buttons which i created in the sheet (When i click the Button it should
expand the group and wen again click the button it needs to be close).
Please help me on this
*
*
*Regards,*
*Jocky*
--
FORUM RULES (93
