CODEWITHSUNDEEP
vbaexcel
Filippo
Filippo

Reputation: 320

Macro not responding on different computer

I have a macro which works fine on my computer when I click its button but it does not work on different computers. All the macros on that excel file are not working when clicking on the button.

However, I have a macro working before saving. That means that when I try to save, another macro works properly. (that macro pop up an input message, but is not relevant now). So it seems that macros are not working only when you call them by a click...

The version of Excel is the same one and I enabled the macro when asked.

It is not a problem of the code because even if I create a new simple macro on that file from the different PC (such as:

msgbox("hello")

) it is still not responding.

I had a problem with that excel file in the past and I had to manually delete all the *.exd extensions in my computer. However once I deleted those extensions, the file worked well.

I believe that the excel file is considered corrupted by other computers and they do not enable the macro. This is just my impression but I cannot get why the macro is working when saving and not working when clicking.

Do you have any idea to solve the problem?

Upvotes: 1

Views: 22617

Answers (2)

djevulen
djevulen

Reputation: 112

I had issues like that myself both with macros and with Excel workbook doing some really funny stuff (like formulas not calculating properly, or functions not working as expected etc) and I did not find any other solution then copying the content of the file and pasting into a newly created file. In each case this resolved my problem. It suggests that my files somehow got corrupted and the only solution was to save the contents and delete the files. Exporting the .frm and .frx files from VBEditor (Modules and Forms) worked fine for me. Have you tried this yourself?

Upvotes: 1

Lucas Kellner
Lucas Kellner

Reputation: 441

This may be too simple a suggestion, but have you checked the security settings in Excel? The other computers may be set to a higher security setting that disables all macros without notifying the user.

https://support.office.com/en-US/Article/Enable-or-disable-macros-in-Office-documents-7b4fdd2e-174f-47e2-9611-9efe4f860b12?ui=en-US

Upvotes: 0

Related Questions