Auto Acknowedge a prompt box?
 

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

Auto Acknowedge a prompt box?
 

Hi,

Application.DisplayAlerts=False works for me.

Regards,

Chris.

--
Chris Marlow
MCSD.NET, Microsoft Office XP Master


"tarns" wrote:


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