View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Austin
 
Posts: n/a
Default How to disable macro prompts for OK in Excel?

I've written a macro that uses the histogram tool. When using the macro, it
generates a dialogue box for "OK" to overwrite existing data which makes me
hit enter on the keyboard. I just want it to continue without prompting when
running the macro. I can't seem to find the magic to disable this. Any
thoughts from anyone. Help much appreciated. Thanks.

Tom