User unable to view custom button or custom toolbar

[Luv2VBA]

Hi,

I'm new to programming in Project (and new to Project in general,
too), and am hoping one of you Project gurus out there can help me.

I have an MS Project file which needs to export certain tasks
(selected by the user) to Excel. I have created code that works and
does what I need, and have created a custom button on the toolbar to
access the code/macro. However, when I send the Project file to any
other user, they are unable to see the custom button I have created.
The user can run the macro I wrote by going into Tools --> Macros -->
Macros, but they just can't see the button I created to bypass this
step.

After searching the newsgroups, I have tried several different things
so far, but none of them work:
1) Right-click on blank area in toolbar, and then go to Customize.
Select "All Macros" from Categories, and then selected my macro from
the Commands list and drag it to an empty space on the toolbar.

2) Created a custom toolbar by going to View --> Toolbars -->
Customize, and clicking New.... Then I added the custom button to the
toolbar as in #1.

3) Under Tools --> Organizer, on the Modules tab, I have verified that
the module that contains my code exists in both the 'Global.MPT' file
and the 'ProjectPlan.mpp' file.

4) Under Tools --> Organizer, on the toolbars tab, I have verified
that the custom toolbar I created (#2 above) exists in both the
'Global.MPT' file and the 'ProjectPlan.mpp' file.

Can anyone think of something or some step that I am missing? I am
really stumped on this one, and unfortunately have no way to test each
new thing I try with my client (who is in another country), except for
continuing to send them a new file each time and ask, "Does this one
work?"

Thank you very much in advance for any input you may be able to
provide!

 

[Mike Glen]

Hi Luv...,

Welcome to this Microsoft Project newsgroup

You're almost there. Your Global.mpt file is probably different to your
client's Global.mpt. You could send yours to them. You could try getting
them to open your file and transfer the appropriate modules using their
Organizer to their Global.mpt.

FAQs, companion products and other useful Project information can be seen at
this web address: http://project.mvps.org/faqs.htm

Hope this helps - please let us know how you get on

Mike Glen
MS Project MVP
See http://tinyurl.com/2xbhc for Project Tutorials

 

[Luv2VBA]

Hi Mike,

Thank you *very* much for your quick response! This did the trick.

Another question that I have is: What is the best way to handle this
when the final Project file template gets distributed to the client's
users? (They only use Project 2000 and 2003, but not Project server).
Will each user then have to receive the final Global.mpt file, and
manually transfer the appropriate modules and/or toolbars to their
Global.mpt file? Is there a better way to do this?

Thank you again for your help!

-Mary

 

[Mike Glen]

You're welcome, Mary (nice to have a name!)

I think this is an either/or situation. Either get them to overwrite their
Global.mpt with yours, or send them the template and manually transfer the
necessary via Organizer.

Mike Glen
MS Project MVP
See http://tinyurl.com/2xbhc for Project Tutorials

 

[Luv2VBA]

Thanks again, Mike!

Just one more question for clarification regarding sending my
Global.mpt to other users: By sending my Global.mpt to another user,
will it overwrite what is in theirs, or will it only add any macros/
toolbars/maps/views, etc. that do not yet exist in theirs? In other
words, if the user has macro XYZ in their Global.mpt, and I send them
my Global.mpt (which does not include macro XYZ), will overwriting
their Global.mpt with mine wipe out their macro XYZ?

Thanks so much for your help and quick responses!

-Mary

 

[Mike Glen]

It will overwrite their Global.mpt and they will lose their customisations.
They can overcome this by opening a project and use the Organizer to copy
their customizations to the project. Then they can reverse this after
copying your Global.mpt.

Mike Glen
Project MVP

 

[Luv2VBA]

OK, this is exactly what I expected.

Thanks so much for your help, Mike! I really appreciate it!

-Mary