Forgive me if I stumble here a bit I'm not the one that builds the macro's. But I can follow directions like a champ!! The Excel Add-Ins that were enabled where: Analysis ToolPak, Analysis ToolPak VBA and Solver Add-in.
Here is the macro code -- it is simple stop and start buttons:
Private Sub CommandButton1_Click()
Cells(Rows.Count, 1).End(xlUp).Offset(1, 0) = Time
Private Sub CommandButton2_Click()
Cells(Rows.Count, 2).End(xlUp).Offset(1, 0) = Time
I wasn't sure if this has anything to do with the issues, so am including it:
'Entry point for RibbonX button click
Sub ShowATPDialog(control As IRibbonControl)
'Callback for RibbonX button label
Sub GetATPLabel(control As IRibbonControl, ByRef label)
label = ThisWorkbook.Sheets("RES").Range("A10").Value
We can see the button on the spreadsheet, but we are not able to click on the button. It is like it is there just as an image. There was no update to office made. The only thing that changed was the excel add-in. We have tried several spreadsheets with this timing macro on the computer and none of the spreadsheets work -- we are not able to click on the button. Now if I take that same excel onto another machine it works just fine.