Hi Anthony-

There could be a number of reasons for each problem you mentioned.

First, toolbars are not stored in the files. They are application items. If
Excel is installed on individual workstations each must be equipped with the
same toolbars.

Macros are a different story. It depends on where the macro was saved.
Again, not always are macros stored in the workbook file. Also, if the other
users have Security set to High, macros will automatically be disabled. If
set to Medium and they neglect to click Enable instead of Disable, the macros
will not run.

Other possibilities exist, but these are some of the first to check out.

HTH |:)

"Anthony" wrote:

Hi,
I have a workbook which is saved on a shared drive in my work office. When I
change or add items to my own created toolbar nothing is shown when a new
user logs on and opens the workbook.
I want them to be able to use the toolbar, but as I say it is never show.
Also some of the macros which I add to the workbook 'drop out'.
This is very frustrating as I update my workbook to make it look and work
better but none of these 'upgrades' seem to show on the 'same' worlbook when
another user logs onto the same drive (S) and uses the same icon for the
workbook.
Can anybody offer a reason as to why this happens and a solution so that all
users can use my workbook.
Many thanks
Anthony