AZ,

This is not possible with a macro... not in the way you are trying
anyway.  The only way around this that I can think of is to set up a
Make-Table Query to create a table with the name of the table you are
trying to delete.  Use an OpenQuery action in your macro to run the
Make-Table before the DeleteObject action.  If the table doesn't already
exist, it will now, so the DeleteObject will proceed without error.  If
it does already exist, the Make-Table will overwrite the existing, but
that doesn't matter since you are trashing it anyway.  You will also
probably want to put a SetWarnings/No action before the OpenQuery, to
suppress the display of the action query confirmation message.