Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Providing Toolbars to Workgroup
I've created a series of useful macros and VBA procedures for our workgroup,
and posted a Macros.xls to a network location, which users copy to their Personal.xls. As expected, the number of useful macros has exceeded the number of meaningful pneumonic hotkeys, so I've assigned hotkeys to the most frequently used, and put the rest on a toolbar. How do I share the toolbar with the group? Thanks. Sprinks |
#2
|
|||
|
|||
First, I wouldn't have the users fiddling around copying and pasting code.
Get a copy of John Walkenbach's MenuMaker workbook: You can find it: http://j-walk.com/ss/excel/tips/tip53.htm After you've done your tweaking, save the file as an addin (*.xla). But name it nicely: SprinksUtils.xla And then save that to a network location and mark it readonly (in windows explorer). Then have the users install it via tools|addins (browse). If some users need to have it available when they're not connected to a network, have them save it to their local harddrive. But you're life will be a little simpler when you're dealing with the network folks. Just put a new version in that file in that network folder and the next time they start excel, they're updated. For the non-network people, Jan Karel Pieterse used a helper workbook that added an addin in his namemanager utility. You can find it at: NameManager.Zip from http://www.oaltd.co.uk/mvp/ He has an installation workbook included in the zip file. === And keep a copy of the name manager for your own use! It's very nice. Sprinks wrote: I've created a series of useful macros and VBA procedures for our workgroup, and posted a Macros.xls to a network location, which users copy to their Personal.xls. As expected, the number of useful macros has exceeded the number of meaningful pneumonic hotkeys, so I've assigned hotkeys to the most frequently used, and put the rest on a toolbar. How do I share the toolbar with the group? Thanks. Sprinks -- Dave Peterson |
#3
|
|||
|
|||
Thanks, Dave, for the general and specific strategies.
Sprinks "Dave Peterson" wrote: First, I wouldn't have the users fiddling around copying and pasting code. Get a copy of John Walkenbach's MenuMaker workbook: You can find it: http://j-walk.com/ss/excel/tips/tip53.htm After you've done your tweaking, save the file as an addin (*.xla). But name it nicely: SprinksUtils.xla And then save that to a network location and mark it readonly (in windows explorer). Then have the users install it via tools|addins (browse). If some users need to have it available when they're not connected to a network, have them save it to their local harddrive. But you're life will be a little simpler when you're dealing with the network folks. Just put a new version in that file in that network folder and the next time they start excel, they're updated. For the non-network people, Jan Karel Pieterse used a helper workbook that added an addin in his namemanager utility. You can find it at: NameManager.Zip from http://www.oaltd.co.uk/mvp/ He has an installation workbook included in the zip file. === And keep a copy of the name manager for your own use! It's very nice. Sprinks wrote: I've created a series of useful macros and VBA procedures for our workgroup, and posted a Macros.xls to a network location, which users copy to their Personal.xls. As expected, the number of useful macros has exceeded the number of meaningful pneumonic hotkeys, so I've assigned hotkeys to the most frequently used, and put the rest on a toolbar. How do I share the toolbar with the group? Thanks. Sprinks -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2002 custom toolbars | Excel Discussion (Misc queries) | |||
Stubborn toolbars in Excel | Excel Discussion (Misc queries) | |||
Getting Excel 2003 to save Custom Toolbars | Excel Discussion (Misc queries) | |||
toolbars keep appearing on opening excel after I removed them bef. | Excel Discussion (Misc queries) | |||
Cant add an icon to toolbars | Excel Discussion (Misc queries) |