Independent Macro Buttons on Same Worksheet

[dbtech]

Hello Experts!

I have been trying to create separate buttons to a worksheet that can be triggered independently of each other. So far I've only been able to make the 2nd one work if the first one has already been activated. These would be for hiding and unhiding separate groups of columns in the spreadsheet.

I want the on-off function to operate so that while one group of columns is showing, the other can be hidden and vice versa.

Any help you could provide would be greatly appreciated.

Thanks in advance!

 

[severynm]

Can you please share the code that you have so far?

 

[dbtech]

Can you please share the code that you have so far?

Hi Severynm,

Thanks for your reply. Here's what I have so far:

Private Sub ToggleButton1_Click()
Dim xAddress As String
xAddress = "J:M"
If ToggleButton1.Value Then
Application.ActiveSheet.Columns(xAddress).Hidden = True
Else
Application.ActiveSheet.Columns(xAddress).Hidden = False
End If
End Sub

Private Sub ToggleButton2_Click()
Dim xAddress As String
xAddress = "N:Q"
If ToggleButton1.Value Then
Application.ActiveSheet.Columns(xAddress).Hidden = True
Else
Application.ActiveSheet.Columns(xAddress).Hidden = False
End If
End Sub


Hope this helps. Thanks again.

 

[severynm]

I have been trying to create separate buttons to a worksheet that can be triggered independently of each other. So far I've only been able to make the 2nd one work if the first one has already been activated. These would be for hiding and unhiding separate groups of columns in the spreadsheet.

I want the on-off function to operate so that while one group of columns is showing, the other can be hidden and vice versa.

It does definitely help, but I'm still a little confused as to what you are looking for, as the items i highlighted seem to contradict each other. Can you elaborate a little more?

 

[dbtech]

I have 4 columns in two separate categories (4 columns each) on the same sheet that I would like to be able to hide and unhide at will. I want one button to hide/unhide one set of columns and another for the other set of columns. Right now, the second button only works if the first button is actuated. This causes both sets of columns to be hidden. I want the buttons to be independent of each other (that is, functioning as two separate buttons) and not have their actions connected as they are now. The first button should be able to hide/unhide the first set of columns and the second button should be able to hide/unhide the second set of columns without relying on the first button's operation. Button2 does not work without Button1.

I hope I did a better job of explaining this time.

 

[dbtech]

I found the answer. I was calling the same button in both codes. Once it was changed to the correct name, it worked like a charm!