LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Auto Acknowedge a prompt box? tarns[_4_] Excel Programming 1 March 10th 06 08:02 AM
Auto rename and save prompt needed. Gizmo63 Excel Worksheet Functions 0 February 7th 06 02:00 PM
Auto-prompt/complete (?) function for number values Raj Mazumdar Excel Discussion (Misc queries) 1 January 10th 06 06:49 PM
Auto close the prompt & dialog boxes HelpEachOther Excel Programming 2 December 21st 05 02:51 AM
How to auto acknowledge a prompt box, Macro gifer Excel Programming 6 March 9th 05 01:17 AM


All times are GMT +1. The time now is 06:01 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"