My vba macro does some deleting of columns and i wish to turn off the
feature where the dialog box prompts me to click 'OK' to delete the
data everytime i run my macro.

I used this code:
'Turn off prompts
DisplayAlerts = False

But no luck.... can someone help me out?


--
tarns
------------------------------------------------------------------------
tarns's Profile: http://www.excelforum.com/member.php...o&userid=32291
View this thread: http://www.excelforum.com/showthread...hreadid=520946