Which copy is your co-worker working from? Is it the one you updated?

"Tami" wrote:

hi harry, sorry to bother you again, but my co-worker was in my file earlier
today when the tool bar only had one button. since then, i have added several
other buttons. but when she opens my file, she still sees just one
button?...we've tried deleting the custom toolbar on her excel but the "old"
toolbar comes back when she opens my file...any suggestions?

"Harry-Wishes" wrote:

Regarding the second part of your question: In Excel, you could distribute
copies of the file that has the custom toolbar to your users as a template.
Each user will be able to run the macros behind the toolbar buttons on their
own data from their local copy. I recently did this with a web project I
completed for my co-workers.

However, I would not include the automacros in the file because you need to
have that toolbar available for other workbooks (it's a long explanation).
Excel works differently when it comes to associating toolbars with Excel
files compared to Word files and it's custom toolbars. I found that the
association can break when the templates reach other users and they may have
to relink the buttons with the correct button the first time they use the
template on a new machine. You'll see what I mean when you actually do it.

Hope that helps.

Harry-Wishes

"Tami" wrote:

Wow that was a fast response...thanks!

ok, so i pasted your macro in the "view code" of that sheet.
i already have a lot of code in my "veiw code" so i pasted it at the
top....a thin grey line appreared beneath each sub. its not working but its
probably because i've pasted in the wrong place?


"Harry-Wishes" wrote:

From my experience, when you add a custum toolbar to an Excel file, the
default appears to be that the toolbar gets associated with that file and
will display even when the file is closed.

I might try inserting an automacro that will hide the toolbar when the file
is closed and insert another automacro that displays the toolbar when the
file is opened. Here is a snippet below.

Cheers!
Harry-Wishes

Sub AutoOpen()
CommandBars("My Bar").Visible = True
end Sub

Sub AutoClose()
CommandBars("My Bar").Visible = False
end Sub

"Tami" wrote:

I have a two-part question.

i've created a custom toolbar named "My Bar"
I have attached to my file.

When i close out of this particular file, "My Bar" remains open. HOw can i
make this custom toolbar open only when in this file and be closed when i
close out of it?

next, many users will copy this file and Save As their own and populate with
their own data. However, we may have new macro to add to that Bar or need to
modify an existing macro on that bar, so it would be nice if it was "My Bar"
was shared or in some central location?...is that possible?