Calling Subroutine from Module

[indrapurkay]

I am a VBA newbie, and have leveraged the knowledge base here to bootstrap my coding. I have run into a strange problem that I am hoping one of the experts can help.

For compatibility with an Add-in that I have, 90% of my program is in Module4, while one subroutine is in Sheet1.
I have a line in my Module4 program

Call Sheets(1).Matrix_program(1)

In two different Laptops one running Excel 2010 and one running Excel 2013 - I have no problems.

In two other Laptops (running Excel 2013) I get the following error
Run-time error '32809':
Application defined or object-defined error

I have reinstalled Excel as well as the Add-In. No luck. It just seems that in these two Laptops, something is preventing calling a subroutine in Sheet1 from a Module.
I have looked through the Security settings, but do not see any difference.
Any suggestion would be welcome.

Thanks

- indra

In the problem

[Kyle123]

Are you sure that the problem isn't with the Matrix_program subroutine itself?

[indrapurkay]

I have exhausted that line of thought before I posted. If the problem were in the Matrix_program, it should have failed in all the Laptops. The fact that it runs in two Laptops, and doesn't in the other two has me stumped.

[Kyle123]

Why not post the code there? There are some changes the user can make to their Excel that could make the code fail, assumptions about the default number of sheets etc. If you post the code we can take a look, there is no way of setting this:

something is preventing calling a subroutine in Sheet1 from a Module

So the issue must lay elsewhere

[indrapurkay]

I removed the entire matrix program, and replaced it with
Public Sub Matrix_program
msgbox ("got here")
End Sub

I still get the same error message.

Interestingly, when I run a simple test macro in the same pc of calling a small program from Module4 to Sheet1, it runs fine.
Is there a size restriction that could be triggering this behavior ?

[Kyle123]

The only way we'll be able to tell us what's causing it is if you upload a sample file that exhibits the same behaviour - without that it's just guessing I'm afraid

[Kyle123]

Or post all your code

[indrapurkay]

After a lot of experimentation, I was able to have a work aroun. The total size of the excel program was about 10MB. I ended up deleting a bunch of forms - with embedded BMPs as the background picture for an on-line help feature. Deleting these reduced the size of the program to 7MB. I now don't have the issue on the two problem PCs.

I don't quite understand why the problem was resolved, and why deleting the forms solved the issue on a PC with 4GB of RAM.