sharing macros

In an excel sheet, I assigned macros to custom buttons. Whenever I sent the
sheet to someone else, the macros were still there but the buttons were not.
So, once I send it to someone, do they have to create the buttons and assign
it to the macros themselves, or is there someway I can save the worksheet or
custom buttons so that when the sheet is opened on another computer they are
already there? Do macros assigned to shortcut keys work the same way (i.e.
they would only work on my computer)?

Sorry if this has been asked before. I searched before I posted and couldn't
find anything that related to this.

Create an addin and put the code in there, and install on all users
machines.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"fabulousk" <[email protected]> wrote in message
news:[email protected]...
> In an excel sheet, I assigned macros to custom buttons. Whenever I sent
the
> sheet to someone else, the macros were still there but the buttons were
not.
> So, once I send it to someone, do they have to create the buttons and
assign
> it to the macros themselves, or is there someway I can save the worksheet
or
> custom buttons so that when the sheet is opened on another computer they
are
> already there? Do macros assigned to shortcut keys work the same way (i.e.
> they would only work on my computer)?
>
> Sorry if this has been asked before. I searched before I posted and
couldn't
> find anything that related to this.

I also found some other questions on the matter and found some details on
adding a custom toolbar. However, when I send the excel sheet through email,
the custom toolbar is attached, but it is not assigned to the correct macros.
Guess I'll keep messing with it until either it works or I've gone crazy.

Thanks for the input!

K

"Bob Phillips" wrote:

> Create an addin and put the code in there, and install on all users
> machines.
>
> --
>
> HTH
>
> RP
> (remove nothere from the email address if mailing direct)
>
>
> "fabulousk" <[email protected]> wrote in message
> news:[email protected]...
> > In an excel sheet, I assigned macros to custom buttons. Whenever I sent
> the
> > sheet to someone else, the macros were still there but the buttons were
> not.
> > So, once I send it to someone, do they have to create the buttons and
> assign
> > it to the macros themselves, or is there someway I can save the worksheet
> or
> > custom buttons so that when the sheet is opened on another computer they
> are
> > already there? Do macros assigned to shortcut keys work the same way (i.e.
> > they would only work on my computer)?
> >
> > Sorry if this has been asked before. I searched before I posted and
> couldn't
> > find anything that related to this.
>
>
>

K,

Make sure that you attach it to the workbook. Do this by going to the View
menu, choose Tool Bars, then Customize. In that dialog, select the Toolbars
tab and click Attach. Select your command bar in the left side list box and
click Attach


--

HTH

RP
(remove nothere from the email address if mailing direct)


"fabulousk" <[email protected]> wrote in message
news:[email protected]...
> I also found some other questions on the matter and found some details on
> adding a custom toolbar. However, when I send the excel sheet through
email,
> the custom toolbar is attached, but it is not assigned to the correct
macros.
> Guess I'll keep messing with it until either it works or I've gone crazy.
>
> Thanks for the input!
>
> K
>
> "Bob Phillips" wrote:
>
> > Create an addin and put the code in there, and install on all users
> > machines.
> >
> > --
> >
> > HTH
> >
> > RP
> > (remove nothere from the email address if mailing direct)
> >
> >
> > "fabulousk" <[email protected]> wrote in message
> > news:[email protected]...
> > > In an excel sheet, I assigned macros to custom buttons. Whenever I
sent
> > the
> > > sheet to someone else, the macros were still there but the buttons
were
> > not.
> > > So, once I send it to someone, do they have to create the buttons and
> > assign
> > > it to the macros themselves, or is there someway I can save the
worksheet
> > or
> > > custom buttons so that when the sheet is opened on another computer
they
> > are
> > > already there? Do macros assigned to shortcut keys work the same way
(i.e.
> > > they would only work on my computer)?
> > >
> > > Sorry if this has been asked before. I searched before I posted and
> > couldn't
> > > find anything that related to this.
> >
> >
> >