Make macros in my Add-In editable with Alt+F8?

[Ed]

I moved all my macros to an Add-In because Normal was getting too
flakey. (One of our IT "upgrades" was making changes to Normal
everytime it opened and closed!) One thing I could do when my macros
were in Normal that I can't do now that they are in an Add-In is use
the Edit button on the Alt+F8 dialog box to view the macro code. A
bit of browsing through the newgroup seems to suggest this behavior is
as designed and expected, and the only way to view the macros is to
open the template itself. Is there no way to allow editing access to
this Add-In?

Ed

 

[Jean-Guy Marcil]

Ed was telling us:
Ed nous racontait que :

I moved all my macros to an Add-In because Normal was getting too
flakey. (One of our IT "upgrades" was making changes to Normal
everytime it opened and closed!) One thing I could do when my macros

I work alone at home, and I never use Normal.dot for anything but temporary
tests that I never save....
Anything serious, I store in global templates.

were in Normal that I can't do now that they are in an Add-In is use
the Edit button on the Alt+F8 dialog box to view the macro code. A
bit of browsing through the newgroup seems to suggest this behavior is
as designed and expected, and the only way to view the macros is to
open the template itself. Is there no way to allow editing access to
this Add-In?

Yes, open the template, as you discovered.

You could create a custom toolbar button (Store the changes in the template
in question, not in Normal.dot) that would open the said template... it
would save you some time.

--

Salut!
_______________________________________
Jean-Guy Marcil - Word MVP
(e-mail address removed)
Word MVP site: http://www.word.mvps.org

 

[Ed]

Ed was telling us:
Ed nous racontait que :


I work alone at home, and I never use Normal.dot for anything but temporary
tests that I never save....
Anything serious, I store in global templates.


Yes, open the template, as you discovered.

You could create a custom toolbar button (Store the changes in the template
in question, not in Normal.dot) that would open the said template... it
would save you some time.

--

Salut!
_______________________________________
Jean-Guy Marcil - Word MVP
(e-mail address removed)
Word MVP site:http://www.word.mvps.org

Thanks, Jean-Guy. I may have to do that. Some of the macros were set
up to allow me to tweak them to the specific doc before running (like
find and replace a Chr() which may be different in the next doc). Or
I may have to do some recoding to allow for input boxes and such.
I'll have to see how much of a hassle this will be.

Cheers!
Ed

 

[Jean-Guy Marcil]

Ed was telling us:
Ed nous racontait que :

Thanks, Jean-Guy. I may have to do that. Some of the macros were set
up to allow me to tweak them to the specific doc before running (like
find and replace a Chr() which may be different in the next doc). Or
I may have to do some recoding to allow for input boxes and such.
I'll have to see how much of a hassle this will be.

Cheers!
Ed

You could add an InputBox statement to get the necessary terms for these
macros. Or if you have time, a userform to get all the necessary variable
info the macros needs before running...
This way you would not need to "edit the macros before running as this would
be included in the code...

--

Salut!
_______________________________________
Jean-Guy Marcil - Word MVP
(e-mail address removed)
Word MVP site: http://www.word.mvps.org