Form in Excel

A

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
 
F

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
 
D

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

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