Macro does not work on all computers

Question

Hi,

all of a sudden my macros do not work on some computers of my colleagues, on others they work.

It's all on W2007/64 and O2010/32. Macros activated.

In the beginning I thought it was the Dec 9th 2014 MS bug, but using the Fixit from MS does not help.

I made a very simple testing file:

I have two Active X buttons on sheet1, which call the following code.

Sub test1()

    ThisWorkbook.Activate

    Sheets("sheet1").Activate

    MsgBox "Done"

End Sub

Sub test2()

    ThisWorkbook.Activate

    Sheets("sheet2").Activate

    MsgBox "Done"

End Sub

In case it is not working, the buttons do not react on the mouse click.

When I run the macros manually the sheets("sheet1").activate does not work, when this sheet is already activated.

Activating a non active sheet works.

My files are already working for more than 10 years on all computers, therefore I have no idea what happened.

Any Idea?

TIA

Wolfgang

Answer 1

Thank you JLLatham and Ron.

Yes I agree, I have to try all these things you mention.

Interesting enough the files for 2104 (and the years before) still work, but the new one's not. However, they are not created on the same machine.

I fear that there is a long way to go to find a solution.

Wolfgang

Answer 2

I agree with RonRosenfeld: try fixing the problem manually on the remaining machines. 

Try to get it fixed on all computers before taking a file from any one of them that still does not work and testing it on any other computer - it seems that just like a virus, a file copied from a non-working system copied to an otherwise properly functioning system causes the problem to be created on the 'good' machine again.  At the very least, don't start copying files from one machine to another until you get them all fixed - put a test file on each one and then start attempting the fixes.

Most people have been able to clear things up with the [FixIt] button on Microsoft's page, but obviously the manual instructions were provided for those where for some reason it just did not work.

Answer 3

Have you tried, on the computers that don't work, either manually fixing the problem (instead of using FIXIT), or doing a restore prior to the time of that update?

Problems associated with that update are the only reason I've seen as being responsible for the issue you describe.

See Form Controls stop working after December 2014 Updates

Answer 4

Hi,

the macro I mentioned works an many computers, but not on all.

The question is:

Why (after 10 years successfully working) the Active X command buttons on the sheet do not work, and the sheet("mySheet").activate does not work for an active worksheet.

Answer 5

try this...

Sub qazx()

With ThisWorkbook

.Sheets(1).Select

MsgBox "Done"

.Sheets(2).Select

MsgBox "Done"

End With

End Sub