Jun 13 2019 06:33 AM
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.
Any ideas please.
Best regards
Philip
Bendigo, Victoria
Australia
Jun 13 2019 05:32 PM
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.
Aug 23 2019 06:23 AM
I have the same problem.
If I include a simple ActiveX button with a simple macro, it will not work.
Clicking the button has no effect but can run the macro manually.