subject:"Re\: $$Excel\-Macros$$ Need help on Micro Button\!\!\!\!\!\!\!\!\!\!\!\!\!\!\!\!\!\!\!"

Re: $$Excel-Macros$$ Need help on Micro Button!!!!!!!!!!!!!!!!!!!

2011-11-14 Thread jocky Beta

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

Re: $$Excel-Macros$$ Need help on Micro Button!!!!!!!!!!!!!!!!!!!

2011-11-14 Thread Sam Mathai Chacko

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: