VBA code made on Excel 2007 not working on Excel 2013

[Loreleii7]

Hi everyone!

I made two buttons using VBA on excel 2007 but they don´t work when I click on them when I open the worksheet on Excel 2013. I don´t receive any error message, they just don´t work.

These are the codes I used:

1st Button: Worksheets("Input").Range("C9, B15:B113, I15:I113, K15:K113").ClearContents

2nd Button: [E12] = [E12] + 1


Does anyone know how I can solve this?

Thank you so much!!

 

[Andrew Poulsom]

Did you enable Macros when you opened the workbook in Excel 2013?

 

[Loreleii7]

Did you enable Macros when you opened the workbook in Excel 2013?

Yes, I did

 

[Andrew Poulsom]

So what do you mean by 'don't work' exactly? Are your buttons ActiveX or Forms Controls?

 

[Loreleii7]

So what do you mean by 'don't work' exactly? Are your buttons ActiveX or Forms Controls?

They are ActiveX.
Actually, I have 2 more buttons that are Form Controls and I recorded a macro for them (for printing) and they work.
The buttons that doesn't work are both ActiveX and both programmed using VBA. I just click on them and nothing happens...

 

[Andrew Poulsom]

Maybe you are in Design Mode.

 

[Loreleii7]

Maybe you are in Design Mode.

Oh no, that was the first thing I checked.

 

[Andrew Poulsom]

So you are clicking on an ActiveX button and it's Click event doesn't fire? The only reason I can think of for that to happen is being in Design Mode or that Macros are not enabled. What do you see when you point at the button?