View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
 
Posts: 3,885
Default 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