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?


--
Desert Piranha


------------------------------------------------------------------------
Desert Piranha's Profile: http://www.excelforum.com/member.php...o&userid=28934
View this thread: http://www.excelforum.com/showthread...hreadid=515617

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.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Desert Piranha"
<Desert.Piranha.23o22n_1140671403.4385@excelforu m-nospam.com wrote in
message news:Desert.Piranha.23o22n_1140671403.4385@excelfo rum-nospam.com...

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?


--
Desert Piranha


------------------------------------------------------------------------
Desert Piranha's Profile:
http://www.excelforum.com/member.php...o&userid=28934
View this thread: http://www.excelforum.com/showthread...hreadid=515617

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Desert Piranha"
<Desert.Piranha.23o22n_1140671403.4385@excelforu m-nospam.com wrote in
message
news:Desert.Piranha.23o22n_1140671403.4385@excelfo rum-nospam.com...

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?


--
Desert Piranha



------------------------------------------------------------------------
Desert Piranha's Profile:
http://www.excelforum.com/member.php...o&userid=28934
View this thread:
http://www.excelforum.com/showthread...hreadid=515617



--
Desert Piranha


------------------------------------------------------------------------
Desert Piranha's Profile: http://www.excelforum.com/member.php...o&userid=28934
View this thread: http://www.excelforum.com/showthread...hreadid=515617