Extra macro icon on toolbar?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ed - 08 Mar 2006 18:48 GMT

I have added several macros to one of my standard toolbars. I just noticed
that one of them shows up twice, same icon pointing to the same macro. I
pulled it off using ALT+Left Mouse, then saved Normal from the VBE and
closed. When I opened Word again, it was back! Any clues as to what's
happening and how to stop it?

Ed

Reply to this Message

Ed - 08 Mar 2006 19:51 GMT

Additional info: a Word doc created through an Excel macro using
Dim WD as New Word.Application
WD.Documents.Open doc
doesn't have the extra icon!

Any answers to this strangeness?
Ed

> I have added several macros to one of my standard toolbars. I just noticed
> that one of them shows up twice, same icon pointing to the same macro. I
[quoted text clipped - 3 lines]
>
> Ed

Reply to this Message

Tony Jollans - 08 Mar 2006 22:24 GMT

It's probably being created by an autoopen (or equivalent) macro - as these
don't run when using automation your additional info would seem to provide
extra evidence to support the theory.

--
Enjoy,
Tony

> Additional info: a Word doc created through an Excel macro using
> Dim WD as New Word.Application
[quoted text clipped - 12 lines]
> >
> > Ed

Reply to this Message

Ed - 08 Mar 2006 23:16 GMT

Thanks for chiming in, Tony. I'm not sure this is the case, though. The
document project has no macros - all code is in Normal. Normal does have an
AutoOpen macro to disable certain toolbars, but nothing else automatic. And
when automating from Excel, the offending document still opens with the
extra icon, while no other doc does. It doesn't seem to cause me any other
problems - I'm just hoping it's not a symptom of something else going very
wrong. I ran CodeCleaner, compiled Normal, and restarted - no joy!

Ed

> It's probably being created by an autoopen (or equivalent) macro - as these
> don't run when using automation your additional info would seem to provide
[quoted text clipped - 21 lines]
> > >
> > > Ed

Reply to this Message

Ed - 09 Mar 2006 15:06 GMT

Seems to have been some document corruption, possibly from deleting some
Sections and then passing it around to different users. I copied everything
except the last paragraph mark and copied into a new blank doc (made sure
the blank doc didn't have the extra icon). Everything's okay now.

Thanks for helping out.
Ed

Reply to this Message

Jonathan West - 08 Mar 2006 20:32 GMT

>I have added several macros to one of my standard toolbars. I just noticed
> that one of them shows up twice, same icon pointing to the same macro. I
[quoted text clipped - 3 lines]
>
> Ed

Hi Ed,

You've probably created the icon twice and saved it in two separate
templates.

If you close all documents & unload all add-ins and you can still see the
icon, that copy of it has probably been saved in Normal.dot. If you open the
Tools Customize dialog and then modify toolbars, the dialog will show you
the template into which the changes will be saved.

Signature

Regards
Jonathan West - Word MVP
www.intelligentdocuments.co.uk
Please reply to the newsgroup
Keep your VBA code safe, sign the ClassicVB petition www.classicvb.org

Reply to this Message

Ed - 08 Mar 2006 21:18 GMT

Thanks for responding, Jonathan. Please see in-line.

> >I have added several macros to one of my standard toolbars. I just noticed
> > that one of them shows up twice, same icon pointing to the same macro. I
[quoted text clipped - 4 lines]
> You've probably created the icon twice and saved it in two separate
> templates.

No - I'm one of those with *everything* (including the kitchen sink!) saved
in Normal. I don't ever use a separate template.

> If you close all documents & unload all add-ins and you can still see the
> icon, that copy of it has probably been saved in Normal.dot. If you open the
> Tools Customize dialog and then modify toolbars, the dialog will show you
> the template into which the changes will be saved.

I've narrowed the odd behavior down to one document (so far). One document
opens with two copies of this icon; all other docs open with one. If I
click on the Word icon in the Office shortcut bar, the new doc has one. If
I open any other file, that file has one icon. I ran my Excel code,
modifying it to open several different docs including the odd one; the odd
doc opens with two icons, all others open with one. All are based on
Normal.

The only difference is this one odd doc is a report which I got from someone
else, modified, gave away, and has now come back. Everything else is
original with my computer. There is no code in this doc, or anything else
to make it different than what I work on every day. In fact, I've had this
doc for a few days, and I'm just now seeing this.

Does that help at all?
Ed

Reply to this Message

Ed - 09 Mar 2006 15:06 GMT

> >I have added several macros to one of my standard toolbars. I just noticed
> > that one of them shows up twice, same icon pointing to the same macro. I
[quoted text clipped - 13 lines]
> Tools Customize dialog and then modify toolbars, the dialog will show you
> the template into which the changes will be saved.

Reply to this Message