digital certificate

[BorisS]

having a bit of a problem with '07 not allowing macros to run on one of my
computers, which I created on another. Both openings are from trusted
locations, but non-generating computer (the one that is trying to run it, not
the one that created it). More specifically, the macro will run, but it
won't let me edit it.

any ideas?

 

[Jay Freedman]

having a bit of a problem with '07 not allowing macros to run on one of my
computers, which I created on another. Both openings are from trusted
locations, but non-generating computer (the one that is trying to run it, not
the one that created it). More specifically, the macro will run, but it
won't let me edit it.

any ideas?

What do you mean by "won't let me edit it"? Can you see the code in the VBA
editor, or is it telling you that the "project is unviewable"?

If it's the "unviewable" message you see, that means you must open the template
that contains the macro, using the Office button > Open (or Ctrl+O) command.

And what does any of this have to do with the subject line "digital
certificate"?

 

[BorisS]

thanks. it was, in fact, "unviewable". How can I tell where the macro is
stored? It shows up in the list of available ones, and I thought I'd once
set up a link in the startup folder to get me to the synched folder in which
I house my Excel Personal and Word Normal templates (both of which, I
thought, held my macros). Any further help would be greatly appreciated.

digital certificate is what the help say is the problem when you look it up
(can't remember how I phrased the problem to find that answer, but definitely
said something about making your own digital certificate with MS Office
tools, or something like that).

 

[Jay Freedman]

Open the Tools > Macro > Macros dialog (Alt+F8). Change the "Macros in" dropdown
to each available template until one of them (other than the "All templates"
choice) shows the name of the macro you want. Then you can close that dialog.

If the template that contains the macro is in the startup folder, it's a good
idea to unload it before opening it. Go to Tools > Templates & Add-Ins and
uncheck the template in the Global list.

Then use the File > Open dialog to open the template, open the VBA editor, and
do your work.

 

[BorisS]

Jay, thanks again. The macro is in the 'Macro Templates.dotm (global
template)', but doing the rest of your mail is tough, as I think we are
either talking about different versions (I am on '07, as I mentioned, and
there is no 'tools' option anymore). Do you know how to accomplish this
"unloading" in '07?

 

[Jay Freedman]

Yes, I had forgotten that your original post did mention Word 2007. Instead of
Tools > Templates & Add-Ins, go to Office button > Word Options > Add-Ins. At
the bottom of the dialog, set the Manage dropdown to "Word Add-Ins" and click
the Go button. The bottom half of the resulting dialog is for global add-ins
(Word's name for templates in the startup folder). Uncheck the macro template
and click OK. Then you can open the template and work on its macros.