K
Kevin McClement
Good afternoon all,
I'm great with Excel, but not so hot on doing much VB...
What i'd like to do is have the Form window open
automatically upon workbook launch. I know the code to
access the Forms menu: ShowDataForm but i need to know
the rest of the code. I tried to record a macro by simply
opening and closing the Form box and editing the VB from
there, but i need help with the open on launch aspect of
it. my first trial opened the form menu and wouldn't let
you close it.
TIA.
To e-mail, please remove the NOSPAM from my listed
address.
Kevin McClement
I'm great with Excel, but not so hot on doing much VB...
What i'd like to do is have the Form window open
automatically upon workbook launch. I know the code to
access the Forms menu: ShowDataForm but i need to know
the rest of the code. I tried to record a macro by simply
opening and closing the Form box and editing the VB from
there, but i need help with the open on launch aspect of
it. my first trial opened the form menu and wouldn't let
you close it.
TIA.
To e-mail, please remove the NOSPAM from my listed
address.
Kevin McClement