excel vba not working

Mstest / Awrdacpi
March 12, 2015 at 06:50:28
Specs: Windows XP, 2 GHz / 958 MB
hi..

i created a macro enabled file and all is perfectly working but when i opened it to another pc/laptop it causes an error and all active x controls is not working. if i create another file using other's laptop/pc with the same codes i created it will work fine. do you think the problem is with the excel installed in my pc?

thanks


See More: excel vba not working

Report •


#1
March 12, 2015 at 09:13:46
What Excel versions are in the two computers?

Always pop back and let us know the outcome - thanks


Report •

#2
March 12, 2015 at 09:33:19
re: it causes an error

That is a very generic statement. Could you be more specific as the the error? What does the text say, what is the error number, "who" is presenting the error (VBA, Excel, the OS), etc.

Have you checked the security settings within Excel on each machine? Each individual instance of Excel has to have the Macro security setting set to allow macros to run and this has to be done manually by the user. You can not force the setting to allow macros to run via a macro due the security related problems that that could cause.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#3
March 13, 2015 at 06:26:42
hi..thanks..our IT at work just reformatted the laptop to work..and it is now okay..i think the excel is corrupted.

thank you for support..


Report •

Related Solutions

#4
March 13, 2015 at 10:43:26
That's good, thanks for the feedback.

Always pop back and let us know the outcome - thanks


Report •


Ask Question