Workbook and Standard Module
 

I have not done any programming, just recorded macros and copied bits of
code from web pages, so please excuse the dumb question, but I have done
searches in Excel help, google groups and not found the answer.

I recently saw a useful looking piece of code, but it was supposed to be put
the in your workbook module (not in a standard
module). Could someone explain in a fairly simply way what the difference
is.

Thanks,
Barbara

Workbook and Standard Module
 

Hi
the workbook and the worksheet modules are used for event procedures.
Good starting points explaining this a
http://www.cpearson.com/excel/events.htm
http://www.mvps.org/dmcritchie/excel/event.htm

--
Regards
Frank Kabel
Frankfurt, Germany


wiseman wrote:
I have not done any programming, just recorded macros and copied bits
of code from web pages, so please excuse the dumb question, but I
have done searches in Excel help, google groups and not found the
answer.

I recently saw a useful looking piece of code, but it was supposed to
be put the in your workbook module (not in a standard
module). Could someone explain in a fairly simply way what the
difference is.

Thanks,
Barbara

Workbook and Standard Module
 

You may also want to do some research on Scope of variables and procedures. Standard modules are meant for user defined Functions, Subs and Variables that are to be project wide, to be called from other procedures.

----- wiseman wrote: ----

I have not done any programming, just recorded macros and copied bits o
code from web pages, so please excuse the dumb question, but I have don
searches in Excel help, google groups and not found the answer

I recently saw a useful looking piece of code, but it was supposed to be pu
the in your workbook module (not in a standar
module). Could someone explain in a fairly simply way what the differenc
is

Thanks
Barbar

Workbook and Standard Module
 

Frank,
Thank you these web pages explained it well.
Barbara.

"Frank Kabel" wrote in message
...
Hi
the workbook and the worksheet modules are used for event procedures.
Good starting points explaining this a
http://www.cpearson.com/excel/events.htm
http://www.mvps.org/dmcritchie/excel/event.htm

--
Regards
Frank Kabel
Frankfurt, Germany


wiseman wrote:
I have not done any programming, just recorded macros and copied bits
of code from web pages, so please excuse the dumb question, but I
have done searches in Excel help, google groups and not found the
answer.

I recently saw a useful looking piece of code, but it was supposed to
be put the in your workbook module (not in a standard
module). Could someone explain in a fairly simply way what the
difference is.

Thanks,
Barbara