Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Custom Toolbars
I have a file that is a master file. Each user opens it up and does a Save
As and names it accordingly. There is a custom toolbar attached that does some basic macros. No i have to add a button to the custom toolbar. How do i do that? do i have to go in to each file...there could be 20 copies out there. Do i rename the new toolbar?...Attach it? but then won''t it have the macros to the master and not the macros in the indiviudal files? I just can't figure out how these toolbars work. thanks in advance for any assistance you can provide. t |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Custom Toolbars
hi
you have a lot of questions and the subject you are dealing with can get complicated. the normal(usual)way of dealing with this(if such a thing exists) is to create the custom toolbar on file open of the master(custom)file then delete the custom toolbar on file exit. since toolbars tend to be pc specific, this allow the users to have the custom toolbar when needed and keep their own personal toolbar setup when not needed. see this site.. http://www.contextures.com/xlToolbar02.html regards FSt1 "Tami" wrote: I have a file that is a master file. Each user opens it up and does a Save As and names it accordingly. There is a custom toolbar attached that does some basic macros. No i have to add a button to the custom toolbar. How do i do that? do i have to go in to each file...there could be 20 copies out there. Do i rename the new toolbar?...Attach it? but then won''t it have the macros to the master and not the macros in the indiviudal files? I just can't figure out how these toolbars work. thanks in advance for any assistance you can provide. t |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Custom Excel Toolbars - how? | Excel Discussion (Misc queries) | |||
Custom Toolbars..? | Excel Discussion (Misc queries) | |||
Custom Menus and Toolbars | Excel Discussion (Misc queries) | |||
Custom toolbars | Excel Discussion (Misc queries) | |||
Showing custom toolbars on one W/S only | Excel Discussion (Misc queries) |