I have created macros that I would like to run when a command button (placed
on the excel worksheet) is clicked. How can I do this?
I have created macros that I would like to run when a command button (placed
on the excel worksheet) is clicked. How can I do this?
View / Toolbars / Forms - Use the Grey button - When drawn it will ask you
what macro you want to assign to it. If not then right click on it and
choose assign macro.
--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03
----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------
"jacchops" <[email protected]> wrote in message
news:[email protected]...
> I have created macros that I would like to run when a command button
(placed
> on the excel worksheet) is clicked. How can I do this?
I thought I could only use those buttons on forms. I was wrong. Thank you so
much!! That couldn't have been any easier.
"Ken Wright" wrote:
> View / Toolbars / Forms - Use the Grey button - When drawn it will ask you
> what macro you want to assign to it. If not then right click on it and
> choose assign macro.
>
> --
> Regards
> Ken....................... Microsoft MVP - Excel
> Sys Spec - Win XP Pro / XL 97/00/02/03
>
> ----------------------------------------------------------------------------
> It's easier to beg forgiveness than ask permission :-)
> ----------------------------------------------------------------------------
>
> "jacchops" <[email protected]> wrote in message
> news:[email protected]...
> > I have created macros that I would like to run when a command button
> (placed
> > on the excel worksheet) is clicked. How can I do this?
>
>
>
:-) You're welcome.
--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03
----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------
"jacchops" <[email protected]> wrote in message
news:[email protected]...
> I thought I could only use those buttons on forms. I was wrong. Thank you
so
> much!! That couldn't have been any easier.
>
> "Ken Wright" wrote:
>
> > View / Toolbars / Forms - Use the Grey button - When drawn it will ask
you
> > what macro you want to assign to it. If not then right click on it and
> > choose assign macro.
> >
> > --
> > Regards
> > Ken....................... Microsoft MVP - Excel
> > Sys Spec - Win XP Pro / XL 97/00/02/03
> >
>
> --------------------------------------------------------------------------
--
> > It's easier to beg forgiveness than ask permission :-)
>
> --------------------------------------------------------------------------
--
> >
> > "jacchops" <[email protected]> wrote in message
> > news:[email protected]...
> > > I have created macros that I would like to run when a command button
> > (placed
> > > on the excel worksheet) is clicked. How can I do this?
> >
> >
> >
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks