Hide/Unhide using Macro in button form

[crenson313]

Hello ,

I am practicing to learn macro in excel , and i choose to go first in hide and unhide option , i have this button named BCD and i try to make a macro of hiding the sheets , i always get error , this is my code.

Sub Hide_Single()
'
' Hide_Single Macro
'

'
 If  Sheets("BCD").Select
   
     ActiveWindow.SelectedSheets.Visible = False
     
     Else
   

       ActiveWindow.SelectedSheets.Visible = True
       
     
End Sub

I ALSO WANT TO HAVE 1 BUTTON THAT CAN HIDE AND UNHIDE EACH CORRESPONDING SHEETS . how will i do that ? thank you

 

[Asheesh]

Duplicate post:

http://chandoo.org/forum/threads/hide-unhide-worksheets-using-button-form-control.25190/#post-151144

You could continue to ask any related questions in the thread that is already in place...