call form from another workbook

Hi, can anyone help a struggling novice please?

I want to call a form (frmDetails) in one workbook (Book1.xls) from another workbook (Book2.xls) but am struggling. I've done it from within the same workbook no problem.

Any suggestions please.

try replacing this: frmDetails

with this: WorkBooks("Book1").frmDetails

Thanks for your suggestion si_the_geek.

However I get an error message 438 'Object doesn't support this property or method'. I can't work out why!

ah ok, it isnt specifically a "child" of the workbook, you need to go thru the VB project too. I cant test it right now, but I think this (or something very similar) will work:

WorkBooks("Book1").VBProject.VBComponents.Item("frmDetails").Show

Gave it a try, after getting a 1004 run time error (Method 'VBProject' of object '_Workbook' failed) I ticked the box for 'Trust access to Visual basic project' in Tools, Macro, Security and then I got the same error message as before (No.438).

If you get time to test it out it would be much appriciated, no rush though, just glad of some help.

Thanks