Toolbar saving problem
 

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

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

If you're making changes to your toolbar, then other users won't see them.

If you attach the toolbar to the workbook, then you'll have a better chance.

If you're going to do that, you'll want to read Jan Karel Pieterse's notes:
http://google.com/groups?threadm=083...0a% 40phx.gbl

It should save some grief later on.

But if you want to avoid all problems, I think you'd be better building the
toolbar on the fly when your workbook opens and deleting it when your workbook
closes.

Here's how I do it:
http://groups.google.co.uk/groups?th...5B41%40msn.com

If you want to add some items to the worksheet menubar, you may want to look at
John Walkenbach's MenuMaker routine.

You can find it:
http://j-walk.com/ss/excel/tips/tip53.htm

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

--

Dave Peterson

Hi CyberTaz (like the name!)

The Excel application we use is on a LAN, and I have my workbook stored on a
shared drive (S). Each time I update this workbook, no updates are shown by
any other work stations which access the workbook from the same shared drive.
The macro problems are not bad enough to worry abt at this stage its just
the toolbar which is driving me mad.
I'll give an example, maybe to help you.

I open the wokbook from the shared drive, and add a new menu to the toolbar.
This menu is degined to allow the user to selct an item from the menu to be
printed.
Once I have done this I then save this workbook again to the same point on
the shared drive (using the same file name). However if I ask another user to
log-on to another PC and open the worksheet (from the same shared drive) my
new menu is not shown....aaaaarrrrggghhhh !!!!

Can You offer any other help, or is it possible to maybe place an icon
(shortcut) on each users desktop for the worksheet so that they can access it
each time they log on, will this work ?? - if so how ??

Kind regards and thanks for your help thusfar

Anthony

"CyberTaz" wrote:

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