Shapes visible is automatically true when pressing ctrl + C/X

[huuchinh1893]

Hi everyone,
I am building a mini tool using excel and vba but I am facing a problem.
I have a rectangle shape is "Rectangle 1" and I use a button to control its visible status (true/false) as below

If Shapes("Rectangle 1").Visible = True Then
    Shapes("Rectangle 1").Visible = False
Else
    Shapes("Rectangle 1").Visible = True
End If

This simple code works fine definitely. The problem happened when I press Ctrl + C any cell in the same sheet, the shape automatically visible back if it was invisible status and I couldn't select the shape or control anything even others still work normally. The excel file is not hanged or crashed.
I checked the visible status at that time but it is not change (still visible = false).
My Office version: 2016 MSO (16.0.4266.1001) 64-bit
Thank for your helps!

 

[CesarF]

Maybe you're using your button's click event or so and it's being fired even when you think it isn't, like when you press CTRL-C... add a debug.print "change..." in your code to test this idea.