As stated

It's my habit and preferred way of doing it 'provided' I'm not reading from
or writing to sheets other than the one that contains the code. Although
there's no reason why worksheet code couldn't work too if doing that

If you believe this is fundamentally incorrect provide a compelling argument
as to why.

Before you reply consider why Microsoft provide a 'general' option in the
dropdown of worksheet modules if entering something other than event code is
inappropriate.

Mike

"Bernd P" wrote:



Several reasons:-

It will work


.... unless some innocent user deletes this special purpose sheet with
the implicit general functionality.

Why not just say 1. Press ALT + F11 2. Insert a new module 3. Copy the
code into the new module 4. Go back to worksheet and use it?

Regards,
Bernd