Subs in personal.xls not found

[alanh99]

I have a need to store a number of 'general' VBA subs in the personal.xls workbook so that they are available from multiple other workbooks. The application is a front end to a Linear program application, and users have the option of creating new scenarios, which involves copying an existing workbook to a new location. My problem is that when I move the subs to personal.xls, I get a 'Runtime error 424 - object required' and the debugger jumps to the sub which calls the sub in personal.xls It is as thought the sub is not there, or the personal.xls module is invisible for some reason, even though it is perfectly visible in the Project List, and the sub works perfectly if it is moved to the calling workbook. I thought that the personal.xls workbook was intended for such situations as this, and am at a loss. Any help gladly received.

[shg]

In the VBE, set a reference in the workbook (Tools > References) to Personal.xls.

[alanh99]

Thanks for the suggestion. I tried it out, but when I do that (attempt to reference Personal.xls via tools) I get an error message 'Name conflicts with existing project...' !!? I will try using a completely different workbook, kept in the root folder of the project, and referenced as you suggest.

[shg]

Your project in Personal.xls should have a unique name for just that reason. Mine is projPersonal.

[alanh99]

Reference accepted now (renamed Personal project as suggested) but original problem was still there. Have renamed sub, and removed full reference to workbook, module etc from object name, and now it works. I am still puzzled as to what the prob was, but will proceed, happlily. Thanks very much!

[shg]

Don't forget to save Personal.xls.

Would you please mark the thread as Solved?

Click the Edit button on your first post in the thread

Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes