Suppressing a message box

I have a sub that monitors changes to the spreadsheet and when a value in a
cell in the range A1:A10 is deleted a default value is entered. A message
box then appears informing the user of the default value.
If a user right-clicks in that range, a menu appears to add/delete. If the
user chooses add, an input box appears for them to add a name (or names
separated by commas). This launches a procedure that inserts a new row and
then places the name entered as the value for the cell. This repeats for all
names entered in the input box.
When the row is added, the first sub kicks in and enters the default value
then displays the message box. When the user clicks ok, the new value is
then entered. Is there a way to bypass or suppress the message box?

application.EnableEvents = False
' code that adds rows and so forth
Application.EnableEvents = True

--
Regards,
Tom Ogilvy


"Matt" <[email protected]> wrote in message
news:[email protected]...
> I have a sub that monitors changes to the spreadsheet and when a value in
a
> cell in the range A1:A10 is deleted a default value is entered. A message
> box then appears informing the user of the default value.
> If a user right-clicks in that range, a menu appears to add/delete. If
the
> user chooses add, an input box appears for them to add a name (or names
> separated by commas). This launches a procedure that inserts a new row
and
> then places the name entered as the value for the cell. This repeats for
all
> names entered in the input box.
> When the row is added, the first sub kicks in and enters the default value
> then displays the message box. When the user clicks ok, the new value is
> then entered. Is there a way to bypass or suppress the message box?
>
>