digital certificate

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?
--
Boris

Jay
Sun Jan 13 20:24:46 PST 2008

On Sun, 13 Jan 2008 20:10:00 -0800, BorisS <BorisS@discussions.microsoft.com>
wrote:

>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"?

--
Regards,
Jay Freedman
Microsoft Word MVP FAQ: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit.

BorisS
Mon Jan 14 13:22:00 PST 2008

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).
--
Boris


"Jay Freedman" wrote:

> On Sun, 13 Jan 2008 20:10:00 -0800, BorisS <BorisS@discussions.microsoft.com>
> wrote:
>
> >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"?
>
> --
> Regards,
> Jay Freedman
> Microsoft Word MVP FAQ: http://word.mvps.org
> Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit.
>

Jay
Mon Jan 14 17:13:16 PST 2008

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.

On Mon, 14 Jan 2008 13:22:00 -0800, BorisS <BorisS@discussions.microsoft.com>
wrote:

>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).

--
Regards,
Jay Freedman
Microsoft Word MVP FAQ: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit.

BorisS
Mon Jan 14 20:28:02 PST 2008

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?
--
Boris


"Jay Freedman" wrote:

> 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.
>
> On Mon, 14 Jan 2008 13:22:00 -0800, BorisS <BorisS@discussions.microsoft.com>
> wrote:
>
> >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).
>
> --
> Regards,
> Jay Freedman
> Microsoft Word MVP FAQ: http://word.mvps.org
> Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit.
>

Jay
Tue Jan 15 16:13:27 PST 2008

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.

On Mon, 14 Jan 2008 20:28:02 -0800, BorisS <BorisS@discussions.microsoft.com>
wrote:

>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?
>--
>Boris
>
>
>"Jay Freedman" wrote:
>
>> 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.
>>
>> On Mon, 14 Jan 2008 13:22:00 -0800, BorisS <BorisS@discussions.microsoft.com>
>> wrote:
>>
>> >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).

--
Regards,
Jay Freedman
Microsoft Word MVP FAQ: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit.