Some times some of the macro and code pieces are advised to be placed at the
worksheet code level and sometimes a separate module operates well. What is
the difference between both and how to identify the same?
--

Best Regards,
FARAZ A. QURESHI

FARAZ QURESHI;241880 Wrote:
Some times some of the macro and code pieces are advised to be placed at
the
worksheet code level and sometimes a separate module operates well.
What is
the difference between both and how to identify the same?
--

Best Regards,
FARAZ A. QURESHI
It depends on how its written, but as a general rule if it
beginsPrivate Sub Worksheetthen its worksheet
code, if it beginsPrivate Sub Workbookit goes
in the Thisworbook module and lastly if it beginsSub
Macroit goes in a standard module and can be prefixed with
Public or Private.


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=67461

See
http://www.rondebruin.nl/code.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"FARAZ QURESHI" wrote in message ...
Some times some of the macro and code pieces are advised to be placed at the
worksheet code level and sometimes a separate module operates well. What is
the difference between both and how to identify the same?
--

Best Regards,
FARAZ A. QURESHI

Hi,

Generally speaking the Sheet and thisWorkbook modules are for event code
related to a specific sheet or thisWorkbook object. When you are in one of
these modules you will notice that you can choose Worksheet or Workbook from
the top left "object" drop down and then a "procedure" from the top right
dropdown. All code associate with these procedures are places in these
modules. In addition ActiveX control have their code here. The "procedures"
found in these modules only work if they are located here, although they can
call code in other modules.

Code can also be placed in Form objects and Class modules as well. Other
code is usually placed in the general modules, but that is not a requirement
in all cases.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"FARAZ QURESHI" wrote:

Some times some of the macro and code pieces are advised to be placed at the
worksheet code level and sometimes a separate module operates well. What is
the difference between both and how to identify the same?
--

Best Regards,
FARAZ A. QURESHI