1st SS can't access 2nd once it is .exe

I have developed 2 x SSs - the 1st contains the data and the 2nd has the forms modules programming etc. the 1st has a reference to the 2nd so that I can update the 2nd SS & the customer does not ‘lose’ any data.

Now once I compile the 2nd SS so I can hide my programming to a .exe the 1st SS can’t access any references that are in the 2nd SS.

How can I get around this ?


What am I doing wrong ?

The EXE files are independant, so the first EXE can’t access data from the second one.
To compile two dependant workbooks, try the Add Companion Files feature. See Use external references and hyperlinks in the guide: