How do I make a button I added to an Excel toolbar work for other users who
are opening the file?

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?

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?

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?

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?

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

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?

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?

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