Sheet event

  • Thread starter Thread starter Bobby
  • Start date Start date
B

Bobby

Hi,
Is there a way(technic) to find out, when a sheet is being called by a
module, to find out the name of the module calling the sheet beside
passing the name of the module has a parameter? (The objectif is to
avoid the execution of an other module in the "Worksheet Active" event
for performance purpose)
Regards.
 
Hi,
Is there a way(technic) to find out, when a sheet is being called by a
module, to find out the name of the module calling the sheet beside
passing the name of the module has a parameter? (The objectif is to
avoid the execution of an other module in the "Worksheet Active" event
for performance purpose)
Regards.
Click to expand...

You can make it so the worksheet event will only occur in a certain
range of the worksheet, but you have not supplied anything useful to
help with this code.
 
You can make it so the worksheet event will only occur in a certain
range of the worksheet, but you have not supplied anything useful to
help with this code.
Click to expand...

The point here is to be able to differentiate when it is a module
calling the sheet or human(clicking on the tab of that sheet). If it
is a module calling I do not want the "Worksheet Active" event to
execute
Thank's ahead for your time.
 
I don't think so.

If you're writing the code, you can turn off all events before your code would
cause an event to fire.

application.enableevents = false
worksheets("sheet999").select
application.enableevents = true
 
I don't think so.

If you're writing the code, you can turn off all events before your code would
cause an event to fire.

application.enableevents = false
worksheets("sheet999").select
application.enableevents = true







--

Dave Peterson- Hide quoted text -

- Show quoted text -
Click to expand...

It does exactly what I was looking for! Thank you Dave.
 
Back
Top