Form in Excel

[Aaron]

I have a form in Excel that I have created and I need this
form to open automatically when the template is opened.
Is there a startup option within Excel like there is
within Access?

Thanks,
Aaron

 

[jeff]

Hi,

yes. Add a macro called Auto_Open()

have it call your form.

jeff

 

[Frank Kabel]

Hi
you could either use a macro called Auto_Open()
or put this code in the Workbook_Open event

I would recommend the latter one as Auto_Open is NOT called if the
workbook is opened via VBA

 

[Dave Peterson]

Unless you run auto_open explictly (runautomacros).

But the opposite case wants to be mentioned <bg>.

If events are disabled, then workbook_open won't run.

 

[Frank Kabel]

Hi Dave
good point(s)

 

[Thomas L. deArth]

Hello,

I working on my thesis and could use some assitance in trying to figure out
to run cross correlation and fourier analysis on my data, which consist of
sets of stream discharge and precipitation data. I purchased "Excel for
engineers and scientists" by S.C. Bloch but found the explanations marginal
and of little help.

Any assistance is greatly appreciated.


Thank you.