How to disable macro prompts for OK in Excel?

Giganews Newsgroups
Subject: How to disable macro prompts for OK in Excel?
Posted by:  Austin
Date: Tue, 9 May 2006

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

Replies