Macro Deleteobject trouble

[ukmale65000]

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

 

[Ron_dK]

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


Hth

 

[ukmale65000]

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

 

[Ron_dK]

OK, then you might try :
Setwarnings to no


Hth