| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can I run a macro from a command button in Excel?
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Can I run a macro from a command button in Excel?
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" wrote in message ... 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? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Can I run a macro from a command button in Excel?
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" wrote in message ... 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? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Can I run a macro from a command button in Excel?
:-) 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" wrote in message ... 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" wrote in message ... 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to create a command button, then assign macro to it in excel | Excel Discussion (Misc queries) | |||
| Applying a macro to a command button, Excel 2002 | Excel Discussion (Misc queries) | |||
| how do you assign a macro to a command button in Excel 2003 | Excel Discussion (Misc queries) | |||
| How do I assign a macro to a command button in excel, office 2003 | Excel Discussion (Misc queries) | |||
| How do i create a command button or macro to exit Microsoft Excel | Excel Worksheet Functions | |||
Linear Mode
