Code will only run when visual basic editor is open

[Liz_I3]

I did get my code tocrun with a workabout but would like to know why code would run wit vbe open but not when closed from a macro button or from view macro run .
Has anyone had this issue? What was the cause?

Thanks
L

 

[MARK858]

Most of the time when I see something similar happen it is because the ranges in the code haven't been qualified with relevant worksheet so it is applying to the wrong worksheet but it is not possible to tell if that is the issue without seeing the code.

 

[Liz_I3]

Thanks I posted the code earlier under title Application defined or object defined error help. Did not want to duplicate. Just very curious has to what would cause this.

 

[Michael M]

The other thread is here

Application defined or object defined error help

This is crazy if I run the below code from the module or have the module open and run it from the view macro dropdown on the excel sheet it works perfect. But if I close the module and run it from the view macro dropdown (from the menu ) I get the Application defined or object defined error...

www.mrexcel.com

and it looks like you solved it ??

 

[Liz_I3]

I did so the the code would run but just a work around never solved the true reason it happened

Thanks

 

[Michael M]

Ahh, so true....but sometimes we never actually find out....Remember, it is Microsoft !!
It might also pay to update your profile details so we know what version / platform, etc you are using...

 

[Liz_I3]

Ok will do but its excel 2016

 

[Michael M]

OK....and Windows or Mac ??
Once it's in the profile, users can provide answers accordingly

 

[Liz_I3]

Windows 10

 

[Michael M]

You need to put this info in your profile....at the top of the page on the RH side you will see your login name. Click on it and then select "Account Details"
Scroll down the page and you can check all that applies to you.