I think the form has to reside in the file. you can put up
a icon to open the form but if the form is not in the
file, the icon wont work.
to export:
open the
vb editor. in the project window right click the
form then click export. the form is export as a text file
with file exention .frm.
to import:
Open the file you wish to have the form in. open the
vb
editor. in the project window right click the file name.
click import file. a dialog box with come up. click the
form file. it should appear in the project window as a
form.
-----Original Message-----
I have created a form for use with one of my worksheets.
How do i make this form usable with multiple workbooks of
the same kind. ?
Do i use add-in ? I want it to become like a item on my
menu bar. Is this possible ?
Regards,
Andy
.