Macro stopped working after enabling Excel Add Ins?

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)
Welcome to the board.

Off the top of my head...

1. Your macro has the same name as a macro/function in the Add-In
2. Your macro uses Public Variables that are also used by the Add-In

I'm sure there are lots of other causes.

Can you post your code, and Which Add-in are you referring to, one of your own (post it's code), or a public one like the Analysis Toolpack?
 
Upvote 0
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
End Sub

Private Sub CommandButton2_Click()
Cells(Rows.Count, 2).End(xlUp).Offset(1, 0) = Time
End Sub




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)
Application.Run ("fDialog")
End Sub

'Callback for RibbonX button label
Sub GetATPLabel(control As IRibbonControl, ByRef label)
label = ThisWorkbook.Sheets("RES").Range("A10").Value
End Sub



Any ideas and help would be great!
Thanks!
Kathy
 
Upvote 0
ok, thanks.

And can you describe "Stop working" ?
What exactly happens?
Do you get an error? What error?
Does macro not do what you expect? What exactly DOES it do? What did you expect it to do?
 
Upvote 0
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.
 
Upvote 0

Forum statistics

Threads
1,212,933
Messages
6,110,757
Members
448,295
Latest member
Uzair Tahir Khan

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top