Cotton has another Excel question

[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.

[Jumping Frog]

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.

[smoothoperator]

You can easily assign macros to buttons. You can also run code automatically when the Excel workbook is opened.

[Charles L. Cotton]

Thanks folks. I'll create a separate sheet to house the buttons.

Chas.

[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.