In the lack of a more appropriate forum, I am posting here.
Macros in Excel (version 2002 if I read right "About.." in the Help menu).
Just completed an application using VBA in Excel with a user form and a custom toolbar involved. The application, "Frame.xls" was saved with two other names. Those copies were erased thus not available.
Trying to activate any macro raises a warning that the copy with the macros is not found. (One of the erased ones is given!!)
I learnt this morning of .xla but I found no way to assign, once for all the macros in "Frame.xla" to my buttons and control. The 3 options given in the menu they do not allow to even search, much less write, "Frame.xla".
I want this application to be run in two or three more computers with no furthe hassle.
Besides the problem above and thinking ahead, even if a overcome all this: what is the right way to "distribute" my application to those PCs with no further hassle other than enabling macros every time I start Excel?
Macros in Excel (version 2002 if I read right "About.." in the Help menu).
Just completed an application using VBA in Excel with a user form and a custom toolbar involved. The application, "Frame.xls" was saved with two other names. Those copies were erased thus not available.
Trying to activate any macro raises a warning that the copy with the macros is not found. (One of the erased ones is given!!)
I learnt this morning of .xla but I found no way to assign, once for all the macros in "Frame.xla" to my buttons and control. The 3 options given in the menu they do not allow to even search, much less write, "Frame.xla".
I want this application to be run in two or three more computers with no furthe hassle.
Besides the problem above and thinking ahead, even if a overcome all this: what is the right way to "distribute" my application to those PCs with no further hassle other than enabling macros every time I start Excel?