Custom buttons
 

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!

Custom buttons
 

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!

Custom buttons
 

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!

Custom buttons
 

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!

Custom buttons
 

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!