Two Macros in one worksheet, Macro1 to hide Macro2 button

[Amanda H]

The worksheet has two macros.

- macro1 clears all fields and hides rows and columns in worksheet
- macro2 opens a new worksheet

The worksheet asks a series of questions and depending on your response macro2 is applicable.

However, I want macro1 to hide macro2 button from view until the response is applicable.

I have tried to hide the row and column in macro1 but macro2 button is still visible.

Any ideas? thanks.

 

[Legacy 143009]

You can use button's Vİsible property

Sheets("Sheet1").CommandButton1.Visible = False
If somecheck Then
  Sheets("Sheet1").CommandButton1.Visible = True
End If

 

[steve the fish]

Or potentially:

Sheets("Sheet1").Buttons("Button 1").Visible = False

 

[Amanda H]

Thank you for your responses.

I had tried that option, but it is only working for the true and not false.

NB: I named the macro button 'shapes' when naming the command button.

See below formula, any help identifying my issue would be greatly appreciated.

 

[Amanda H]

Thank you for your responses.

I had tried that option, but it is only working for the true and not false.

NB: I named the macro button 'shapes' when naming the command button.

See below formula, any help identifying my issue would be greatly appreciated.

Or potentially:

Sheets("Sheet1").Buttons("Button 1").Visible = False

 

[Legacy 143009]

Sorry, I have no idea. Maybe @steve the fish can help.