View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] 1404ottawa@gmail.com is offline
external usenet poster
 
Posts: 6
Default hide & unhide toggle button

On Wednesday, October 31, 2012 3:26:28 PM UTC-4, wrote:
Private Sub CommandButton1_Click()



Dim myRow As Long

Dim myAdr As String



myRow = ActiveCell.Row

myAdr = ActiveCell.Offset(0, -1).Address(0, 0)

Range("B" & myRow & ":" & myAdr).EntireColumn.Hidden = True

The macro above will hide COL B to any selected col

What can I add to thsi macro in order to toggle between hiding and unhiding that data.

Much appreciate your help


Worked great Tank you very much