| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
User Forms availabilty to all workbooks
I am trying to use a group of user forms in several different woorkbooks that
will be linked. I want the user forms accessible from any of the workbooks when certain command buttons are clicked. Can anyone please help on this. Thanks |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
User Forms availabilty to all workbooks
You could either put it in your PERSONAL MACRO WORKBOOK or develop it into
an addin... How to create a macro *template* to store macros to be available in all workbooks: http://www.personal-computer-tutor.com/personalxls.htm Microsoft Excel VBA Macros. How to Create an Excel Add-in For Them http://www.ozgrid.com/VBA/excel-add-in-create.htm "Mark Ojie" <Mark wrote in message ... I am trying to use a group of user forms in several different woorkbooks that will be linked. I want the user forms accessible from any of the workbooks when certain command buttons are clicked. Can anyone please help on this. Thanks |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
User Forms availabilty to all workbooks
Thanks Mark,
I am abit new to the VBA programming. this application will eventually be distributed to non networked systems does that mean i will have to install the addin on each local system. I am trying to stay away from the use of a pure database Again thanks for the help "Mark Ivey" wrote: You could either put it in your PERSONAL MACRO WORKBOOK or develop it into an addin... How to create a macro *template* to store macros to be available in all workbooks: http://www.personal-computer-tutor.com/personalxls.htm Microsoft Excel VBA Macros. How to Create an Excel Add-in For Them http://www.ozgrid.com/VBA/excel-add-in-create.htm "Mark Ojie" <Mark wrote in message ... I am trying to use a group of user forms in several different woorkbooks that will be linked. I want the user forms accessible from any of the workbooks when certain command buttons are clicked. Can anyone please help on this. Thanks |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
User Forms availabilty to all workbooks
I am not sure of all your specifics, but if it needs to be portable I would
strongly recommend the addin option. If you need help with specifics, you could post your code and there are several that might be able to help you out. Even better... if you have a place to upload your stuff to the web... it would be much easier to see some real examples. Mark Ivey "Mark Ojie" wrote in message ... Thanks Mark, I am abit new to the VBA programming. this application will eventually be distributed to non networked systems does that mean i will have to install the addin on each local system. I am trying to stay away from the use of a pure database Again thanks for the help "Mark Ivey" wrote: You could either put it in your PERSONAL MACRO WORKBOOK or develop it into an addin... How to create a macro *template* to store macros to be available in all workbooks: http://www.personal-computer-tutor.com/personalxls.htm Microsoft Excel VBA Macros. How to Create an Excel Add-in For Them http://www.ozgrid.com/VBA/excel-add-in-create.htm "Mark Ojie" <Mark wrote in message ... I am trying to use a group of user forms in several different woorkbooks that will be linked. I want the user forms accessible from any of the workbooks when certain command buttons are clicked. Can anyone please help on this. Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| New to User Forms | New Users to Excel | |||
| user forms | Excel Programming | |||
| Updating VBA Modules and Forms in User Workbooks | Excel Programming | |||
| User Forms | Excel Programming | |||
| User Forms | Excel Programming | |||
Linear Mode
