| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Buttons in a toolbar
How do I make a button I added to an Excel toolbar work for other users who
are opening the file? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Buttons in a toolbar
hi,
toolbar button are unique to the machine. they don't follow the file. i might suggest that you put a command button on the sheet. command buttons follow the file. Regards FSt1 "Daddio_1962" wrote: How do I make a button I added to an Excel toolbar work for other users who are opening the file? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Buttons in a toolbar
hi
Afterthought.... you could copy the button and paste it in a xl file then put it on the other machines. but i would still recomend the command button on the sheet. Regards FSt1 "FSt1" wrote: hi, toolbar button are unique to the machine. they don't follow the file. i might suggest that you put a command button on the sheet. command buttons follow the file. Regards FSt1 "Daddio_1962" wrote: How do I make a button I added to an Excel toolbar work for other users who are opening the file? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Buttons in a toolbar
If you create a new Toolbar with your button on it, you can attach that Toolbar
to the file. ToolsCustomizeToolbarsNew. Give it a name like MyBar Add a smileyface button from Macros under Commands. Right-click on that button and assign your macro. Make any changes you want to the button name or button face. When happy, ToolbarsAttach. Select and "Copy" Save Workbook. Gord Dibben MS Excel MVP On Mon, 14 Jan 2008 13:38:01 -0800, Daddio_1962 wrote: How do I make a button I added to an Excel toolbar work for other users who are opening the file? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Buttons in a toolbar
toolbar button are unique to the machine. they don't follow the file.
They do if you Attach the toolbar to the workbook. -- Cordially, Chip Pearson Microsoft Most Valuable Professional Excel Product Group, 1998 - 2008 Pearson Software Consulting, LLC www.cpearson.com (email on web site) "FSt1" wrote in message ... hi, toolbar button are unique to the machine. they don't follow the file. i might suggest that you put a command button on the sheet. command buttons follow the file. Regards FSt1 "Daddio_1962" wrote: How do I make a button I added to an Excel toolbar work for other users who are opening the file? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Buttons in a toolbar
If you're executing a macro that you created, I think your life will be lots
easier if you create that toolbar when the workbook opens and destroy it when the workbook closes. Some references if you want to look at that option: For additions to the worksheet menu bar, I really like the way John Walkenbach does it in his menumaker workbook: http://j-walk.com/ss/excel/tips/tip53.htm Here's how I do it when I want a toolbar: http://www.contextures.com/xlToolbar02.html (from Debra Dalgleish's site) And if you use xl2007: If you want to learn about modifying the ribbon, you can start at Ron de Bruin's site: http://www.rondebruin.nl/ribbon.htm http://www.rondebruin.nl/qat.htm -- For macros for all workbooks (saved as an addin) or http://www.rondebruin.nl/2007addin.htm In xl2007, those toolbars and menu modifications will show up under the addins. Daddio_1962 wrote: How do I make a button I added to an Excel toolbar work for other users who are opening the file? -- Dave Peterson |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Buttons in a toolbar
hi
i just learned somthing. how do you attach it to the file? regards FSt1 "Chip Pearson" wrote: toolbar button are unique to the machine. they don't follow the file. They do if you Attach the toolbar to the workbook. -- Cordially, Chip Pearson Microsoft Most Valuable Professional Excel Product Group, 1998 - 2008 Pearson Software Consulting, LLC www.cpearson.com (email on web site) "FSt1" wrote in message ... hi, toolbar button are unique to the machine. they don't follow the file. i might suggest that you put a command button on the sheet. command buttons follow the file. Regards FSt1 "Daddio_1962" wrote: How do I make a button I added to an Excel toolbar work for other users who are opening the file? |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Buttons in a toolbar
Start he
http://www.jkp-ads.com/Articles/DistributeMacro04.htm Jan Karel Pieterse's site (but you may want to consider creating that toolbar in code) FSt1 wrote: hi i just learned somthing. how do you attach it to the file? regards FSt1 "Chip Pearson" wrote: toolbar button are unique to the machine. they don't follow the file. They do if you Attach the toolbar to the workbook. -- Cordially, Chip Pearson Microsoft Most Valuable Professional Excel Product Group, 1998 - 2008 Pearson Software Consulting, LLC www.cpearson.com (email on web site) "FSt1" wrote in message ... hi, toolbar button are unique to the machine. they don't follow the file. i might suggest that you put a command button on the sheet. command buttons follow the file. Regards FSt1 "Daddio_1962" wrote: How do I make a button I added to an Excel toolbar work for other users who are opening the file? -- Dave Peterson |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Buttons in a toolbar
Read my post.
Gord On Mon, 14 Jan 2008 18:53:01 -0800, FSt1 wrote: hi i just learned somthing. how do you attach it to the file? regards FSt1 "Chip Pearson" wrote: toolbar button are unique to the machine. they don't follow the file. They do if you Attach the toolbar to the workbook. -- Cordially, Chip Pearson Microsoft Most Valuable Professional Excel Product Group, 1998 - 2008 Pearson Software Consulting, LLC www.cpearson.com (email on web site) "FSt1" wrote in message ... hi, toolbar button are unique to the machine. they don't follow the file. i might suggest that you put a command button on the sheet. command buttons follow the file. Regards FSt1 "Daddio_1962" wrote: How do I make a button I added to an Excel toolbar work for other users who are opening the file? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| showing buttons in the toolbar | Excel Discussion (Misc queries) | |||
| finding buttons that should appear in toolbar | Setting up and Configuration of Excel | |||
| Toolbar buttons | Excel Discussion (Misc queries) | |||
| How can I keep Toolbar Buttons on the toolbar? | Setting up and Configuration of Excel | |||
| Toolbar Buttons | Excel Discussion (Misc queries) | |||
Linear Mode
