My PC has rebooted itself three times today (13th June 2019) through automatic updating.
I do not know why but the ActiveX 'button' in one of my key workbooks has now ceased to work. I used an ActiveX 'button' because I wanted better control over its background colour, which a basic form button does not allow for.
I have a workbook with multiple worksheets. Near the 'end' of the workbook is a statistical sheet, which also serves as a clickable table of contents. Those table of contents functionalities have not been corrupted.
On each of the main worksheets there is an ActiveX 'button', which is named CommandButton1 (the name the system gave it when I first created it about 15 days ago). On examining it in Design Mode, it appears to still be an ActiveX 'button' with its text and colour formatted correctly and the code view is what I expected (see below) BUT the button has just simply ceased to work.
ThisWorkbook Level Module
Sub Goto_GSUTPF_Index() Worksheets("Coverage_Statistics").Activate End Sub
Sheet Level Module
Private Sub CommandButton1_Click() CommandButton1.BackColor = 4349166 ThisWorkbook.Goto_GSUTPF_Index End Sub
I have closed, re-opened, saved a few times but no effect.
I do, most strangely, also appear to have ended up with two identical copies of the same VBAProject.
This one appears to have cleared itself up after 24 hours. I don't know why; I changed nothing, but did close, and reopen, the affected workbook a couple of times. That's the way things go sometimes, I suppose.