You may be able to adapt the ideas documented by
http://support.microsoft.com/default...;en-us;Q157609

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article , NoToSPAM@home
says...
Take It, It Can't be done..?
Thanx anyway.
| From: "Andrew" <NoToSPAM@home
| Subject: How to close forms opened from other workbooks...?
| Date: Sun 12 June 2005 20:22
|
| I have a form that is loaded(show) from Personal.xls.
| Other workbooks can then be opened.
|
| Q. how is it possible to check if the form (Main.FRM) is open and close it
| or reference a listbox item if it is open.
|
| Is there a way of:
| If Userforms("Main") then
| ThisTextbox.text=Workbooks("Personal").Main.TextBo x1.Text
| end if
|
| Thanks for any Help.
| Andrew