Why don't custom buttons "travel" with a spreadsheet? I assigned a couple
of macros to custom buttons, saved the spreadsheet and emailed it to my boss
for him to view and the buttons weren't there. Why not? Can it be done?

TIA!

If I'm creating a spreadsheet with toolbars, I'll create them as temporary
with code.
See Commandbar examples on my website.

--
Rob van Gelder - http://www.vangelder.co.nz/excel


"Bryan Dickerson" wrote in message
...
Why don't custom buttons "travel" with a spreadsheet? I assigned a couple
of macros to custom buttons, saved the spreadsheet and emailed it to my
boss
for him to view and the buttons weren't there. Why not? Can it be done?

TIA!

Again, that's exactly what I need. Didn't know I could do that, but that's
what newsgroups like this are for. Thanx!

"Rob van Gelder" wrote in message
...
If I'm creating a spreadsheet with toolbars, I'll create them as temporary
with code.
See Commandbar examples on my website.

--
Rob van Gelder - http://www.vangelder.co.nz/excel


"Bryan Dickerson" wrote in message
...
Why don't custom buttons "travel" with a spreadsheet? I assigned a
couple
of macros to custom buttons, saved the spreadsheet and emailed it to my
boss
for him to view and the buttons weren't there. Why not? Can it be
done?

TIA!

One more question:
How do I position my commandbar at the end of an existing commandbar? I.e.
to preserve a bit of screen real-estate, I find myself dragging(moving) the
custom commandbar around to the end of the 1st or 2nd row of commandbars.
How would I do this programmatically?

"Bryan Dickerson" wrote in message
...
Again, that's exactly what I need. Didn't know I could do that, but
that's
what newsgroups like this are for. Thanx!

"Rob van Gelder" wrote in message
...
If I'm creating a spreadsheet with toolbars, I'll create them as
temporary
with code.
See Commandbar examples on my website.

--
Rob van Gelder - http://www.vangelder.co.nz/excel


"Bryan Dickerson" wrote in message
...
Why don't custom buttons "travel" with a spreadsheet? I assigned a
couple
of macros to custom buttons, saved the spreadsheet and emailed it to
my
boss
for him to view and the buttons weren't there. Why not? Can it be
done?

TIA!

I did something similar about a year ago - my how time flys.

http://groups.google.com/groups?hl=e... ngp13.phx.gbl

--
Rob van Gelder - http://www.vangelder.co.nz/excel


"Bryan Dickerson" wrote in message
...
One more question:
How do I position my commandbar at the end of an existing commandbar?
I.e.
to preserve a bit of screen real-estate, I find myself dragging(moving)
the
custom commandbar around to the end of the 1st or 2nd row of commandbars.
How would I do this programmatically?

"Bryan Dickerson" wrote in message
...
Again, that's exactly what I need. Didn't know I could do that, but
that's
what newsgroups like this are for. Thanx!

"Rob van Gelder" wrote in message
...
If I'm creating a spreadsheet with toolbars, I'll create them as
temporary
with code.
See Commandbar examples on my website.

--
Rob van Gelder - http://www.vangelder.co.nz/excel


"Bryan Dickerson" wrote in message
...
Why don't custom buttons "travel" with a spreadsheet? I assigned a
couple
of macros to custom buttons, saved the spreadsheet and emailed it to
my
boss
for him to view and the buttons weren't there. Why not? Can it be
done?

TIA!