Page 1 of 1
Cotton has another Excel question
Posted: Wed May 30, 2012 2:02 pm
by Charles L. Cotton
Can a control panel/page/sheet be created in Excel that can be used to launch macros? I'm thinking of something like the Access switchboard. I've searched but can't find anything.
Thanks,
Chas.
Re: Cotton has another Excel question
Posted: Wed May 30, 2012 6:39 pm
by Jumping Frog
Charles L. Cotton wrote:Can a control panel/page/sheet be created in Excel that can be used to launch macros? I'm thinking of something like the Access switchboard. I've searched but can't find anything.
Thanks,
Chas.
Sure. Depends upon what version of Excel for the exact menu choices. Go to the designer menu, Controls, and Insert a button control. You can assign any macro you want to the button_click event. You can label with any text you want.
If you want to get more complicated, you can also insert radio buttons, combo boxes, check boxes, spin controls, etc.
If you want some specific help, you can shoot me a PM or email.
Re: Cotton has another Excel question
Posted: Wed May 30, 2012 6:42 pm
by smoothoperator
You can easily assign macros to buttons. You can also run code automatically when the Excel workbook is opened.
Re: Cotton has another Excel question
Posted: Wed May 30, 2012 8:40 pm
by Charles L. Cotton
Thanks folks. I'll create a separate sheet to house the buttons.
Chas.
Re: Cotton has another Excel question
Posted: Wed May 30, 2012 9:17 pm
by terryg
You may already be aware of the following:
What version of Excel are you running? In 2007 and up, if you click on the big office button in the top left and select Excel Options, you should see a check box for "Show Developer tab in the Ribbon". This will add a tab that has various controls.