Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to make my FORM usable across multiple worksheets?
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to make my FORM usable across multiple worksheets?
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 . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to make my FORM usable across multiple worksheets?
Frank,
An addin is a good idea for portable, shareable code if you have created a program that you can run against many worksheets of the same kind, although the form and code could merely reside in your PERSONAL.XLS workbook (or any other hidden workbook with code in it that you add to your XLStart folder). It is possible to add items to menus or create new menus programmatically or manually. Look for code samples using Google Groups or one of the MVP sites which you can find (guess where?) using Google. You can also create a custom toolbar which can be "attached" to a workbook (see Tools Customize) so the toolbar goes with the workbook if you want to pass it on to others. Bob "Frank Stone" wrote in message ... 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 . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to make my FORM usable across multiple worksheets?
I mean, Andy...
"Bob Kilmer" wrote in message ... Frank, An addin is a good idea for portable, shareable code if you have created a program that you can run against many worksheets of the same kind, although the form and code could merely reside in your PERSONAL.XLS workbook (or any other hidden workbook with code in it that you add to your XLStart folder). It is possible to add items to menus or create new menus programmatically or manually. Look for code samples using Google Groups or one of the MVP sites which you can find (guess where?) using Google. You can also create a custom toolbar which can be "attached" to a workbook (see Tools Customize) so the toolbar goes with the workbook if you want to pass it on to others. Bob "Frank Stone" wrote in message ... 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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Re-usable form | Excel Discussion (Misc queries) | |||
make macros usable! make instructions in plain english !!!! | Excel Worksheet Functions | |||
In EXCEL2000, How can I copy a file and make it usable in MS WORK | Excel Discussion (Misc queries) | |||
download will not open in usable form | Excel Worksheet Functions | |||
How to make an Excell-sheet un-usable! | Excel Programming |