This is my 1st post on here, apologies if I don't do it correctly! I'm also relatively new to coding, so
apologies in advance if I'm not clear enough in my explanation of my problem.
Basically, I have the following
I have a form button on a tab in my workbook. Attached to this button is a macros that will run when the
button is clicked (pretty standard stuff so far).
Within the code of the actual tab itself, I have a Private Sub
that makes the button visible if a condition in a cell is met, and hides the button completely if the condition is not met.
Here is the code I am using:
Private Sub Worksheet_Change(ByVal Target As Range)
v1 = Range("M12").Value
If v1 = "DISABLE" Then
Sheets("CHANGE PERIOD").Shapes("Button 14").Visible = False
Sheets("CHANGE PERIOD").Shapes("Button 14").Visible = True
However, I want to rename the form button to something that explains what the button does but when I do, it stops the above
code from working.
If I change the "(Button 14") part to the new name of my button, it still doesn't
I have also tried to create a new button & when it asks you to assign a Macros, have tried editing the
name in the top left of this box also, ie 'Button1_Click' to whatever I need.
Is there a way around this, so my
form button is called something more descriptive than 'Button 14'?!
Thanks in advance