Macro Deleteobject trouble (1 Viewer)

I currently run a macro which deletes a temp table using the delete object command.
Users are then presented with a warning box that says "You are about to modify data etc" which I dont want them to see I just want the macro to run and make any modifications automatically.
I have looked in the help menu and it says go to Tools/Options/ Edit/Find and untick the confirm record change box, that is where my trouble starts as this box is not ticked in the first place.
Any ideas???
TIA

Go to your macro in design mode and delete the action line MsgBox.


Hth

Would love to say there was a line Msgbox but there isnt ????

OK, then you might try :
Setwarnings to no


Hth