Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto Acknowedge a prompt box?
tarns,
Now you see the benefit of "Option Explicit" at the top of all code. It "does not work" because you are not affecting Excel; you are setting your own variable called DisplayAlerts to False Check the Help for the correct syntax. NickHK "tarns" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto Acknowedge a prompt box? | Excel Programming | |||
Auto rename and save prompt needed. | Excel Worksheet Functions | |||
Auto-prompt/complete (?) function for number values | Excel Discussion (Misc queries) | |||
Auto close the prompt & dialog boxes | Excel Programming | |||
How to auto acknowledge a prompt box, Macro | Excel Programming |