macros doesn´t work on different PC

[hordaT]

Hello guys,

have you ever seen an issue that your macros doesn´t work on PC with different language?

It gaves no error message, nothing, just do not work. Yes, macros are enabled in excel security.

When I tried to View Code of one push button, then it redirected me to VB, but created new sub with different pushbutton name.

Do you have any ideas how to solve this issue?

Thanks

 

[RoryA]

Can you run the macros directly from the VB Editor using f5 or via the macros dialog, rather than via a button? If so, I suspect the issue is the recent activex problem, not a language issue.

 

[Jake Blackmore]

Is it simply that the pushButton has simply changed it's name and therefore the code is no longer assigned to it - hence why it's creating a new sub for you? This could well be because of the change of language settings.

 

[hordaT]

Hello guys,

thank you for prompt answers.

to RoryA:
I´ve tried to run it directly from VB editor, but without any differences. I´ve also tried another PC with the same language and it was not working at all. Interresting thing is that I´ve created new sheet with simple macro and tried it on second PC with the same result. Interresting is that when I´ve created identical macro with new sheet in second PC, then it worked on mine.

It might be that recent issue with activeX object (my PC is the only one where IT has installed some patch), however there are not any working macros created in my PC that works on other PC. I´ll try to install that patch and see if it helps.

to Jake Blackmore:
Good point and in fact it was the very first thing I´ve tried. Unfortunately it didn´t helped. I´ve also tried to save my sheet on second PC and now excel is really funky - I even can´t delete that renamed pushbutton as excel crashes every time I try it

 

[RoryA]

Changing language settings should never change the name of a button.

If you create a macro in a new workbook that doesn't use any activex controls, can you run it on the other PC?

 

[Jake Blackmore]

Thank you RoryA

Can I ask what is the Macro - does it have something user specific in it like Environ?
Jake

Changing language settings should never change the name of a button.

If you create a macro in a new workbook that doesn't use any activex controls, can you run it on the other PC?

 

[hordaT]

Thank you RoryA,

when I tried new sheet with simple macro without activeX, then it worked fine.

My original sheet also contain macros without activeX control, but unfortunately it seems that simple presence of activeX object in that sheet blocks execution of any macro.


to Jake Blackmore:
I´ve used several macros in my original sheet. For example: Case, if, macro to copy from excel to word, to show user Form,...

There are only 2activeX object in my sheet - First one have simple command to show Form and second one to execute simple IF and call for another sub.


EDIT:
If I create new sheet with macro without activeX, then it works on both PC. However when I insert any activeX object to the same sheet, previously working macro is not executed on second PC.

 

[Jake Blackmore]

Hi - just curious (as I'm still learning) why you choose to ActiveX for those activities? Couldn't you run them all from an object like shapes as they always seem to offer far more in the way of aesthetics anyway?

 

[RoryA]

Your issue is definitely the recent update bug then. All machines need to have the updates applied, and the FixIt run on them, or you can't share workbooks that use activex between them. If possible, replace them with Form controls, or shapes as Jake suggested.

 

[hordaT]

Hi Jake,

I´m still learning too . I chose activeX objects for direct execution of my macro. With standard form control I have to asign macro from module. It is not any problem, just less comfortable.


Anyway, I´d like to thank to you Jake and also to RoryA to give me ideas how to solve it. I´ve used Form Control objects instead of activeX and now it works.


Thank you guys