Buttons

[Guest]

Is there a way to create a button that will do the following:

Open the TOOLS menu
Open DATA ANALYSIS
Choose REGRESSION

and then have the regression window open and ready for me? I have to do
several of these and I was just looking for a quicker way to do this rather
than going through this process each time I want to do a regression analysis.

Thanks.

Chris

 

[Gord Dibben]

Chris

You must have the Analysis Toolpak add-in enabled to start with.

Next, record a macro whilst you go through the above steps.

Assign that macro to a button on your toolbar.

Gord Dibben Excel MVP