Worksheet_Change sub does not trigger a called macro
Hi Herman
two ideas:
- is the code in the worksheet module of your sheet?
- Maybe the Application events are disbaled (due to testing / error,
etc): Input the statement
Application.EnableEvents = True
in the Intermediate windows and try again
Frank
herman wrote:
Why does this Worksheet_Change Sub NOT trigger the macro that it
calls
although it triggers the selection of range b16 at the end and
although the called macro works perfectly if called in another way
(e.g.by F5).
There are three charts in my workbook that I want to automaticly
update when the "Sensi" range is touched. Is there any better way to
do what I'm trying? I can't trust the automatic axis scaling of my
charts.
Thank you very much for your help.
Herman
|