WorkBook VS General Module

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Desert Piranha - 23 Feb 2006 05:01 GMT

Hi All,

Question is for either WorkBook Open or WorkBook Close.

Scenario # 1:
Code in WorkBook Open.

Scenario # 2:
Code in General Module with a Call in WorkBook Open.

Is there any advantages or disavantages to either scenario, other than
the call method uses more code?

Signature

Desert Piranha

Reply to this Message

Bob Phillips - 23 Feb 2006 08:26 GMT

Both are workable, but scenario #2 is more general as that procedure can
easily be called elsewhere. Personally, I try to just use the event code in
Thisworkbook, and any common routines that get called are put in a general
module.

Signature

HTH

Bob Phillips

(remove nothere from email address if mailing direct)

> Hi All,
>
[quoted text clipped - 8 lines]
> Is there any advantages or disavantages to either scenario, other than
> the call method uses more code?

Reply to this Message

Desert Piranha - 24 Feb 2006 03:41 GMT

Hi Bob,

Thanks for your info, i appreciate it.

Thanks
Dave
Bob Phillips Wrote:

> Both are workable, but scenario #2 is more general as that procedure
> can
[quoted text clipped - 38 lines]
> > View this thread:
> http://www.excelforum.com/showthread.php?threadid=515617

Signature

Desert Piranha

Reply to this Message