Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
saving change in toolbar | Excel Worksheet Functions | |||
Row Autofit problem Excel 2003 | Excel Discussion (Misc queries) | |||
saving toolbar | Excel Discussion (Misc queries) | |||
Saving a Excel 97 file into Excel 2003 file | Excel Discussion (Misc queries) | |||
"Drawing" Toolbar is inactive | Excel Discussion (Misc queries) |