Prev: External Data
Next: Make protected hidden row & column headers appear and rehide based
From: Allan_Urban on 25 Sep 2009 08:38
It seems like you have to run the regression manually when you open the sheet
before it works.

Is there a way to bypass this?
From: Jacob Skaria on 25 Sep 2009 09:01
Save this as a macro and Call this macro from Workbook_Open event.

VBE>VBAProject(Your_Filename) >Microsoft Excel Objects>double click 'This
Workbook' and in the code panel you can list down the workbook events.

If this post helps click Yes
---------------
Jacob Skaria


"Allan_Urban" wrote:

> It seems like you have to run the regression manually when you open the sheet
> before it works.
>
> Is there a way to bypass this?
From: Allan_Urban on 25 Sep 2009 09:31
Doesn't work. I still have to Data > Data analysis > Regression >...
manually before the macro works.
First  |  Prev  | 
Pages: 1 2
Prev: External Data
Next: Make protected hidden row & column headers appear and rehide based