| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA to "answer" spesific msg box
I am wondering if it is possible to write an macro that answers "no when a spesific alert is shown in Excel 2003. The alert is the aler where excel asks you if you want to save the excel document becaus "excel recalculates formulas when opening files last saved by a earlier version of Excel". I like to keep track of the dates when documents ar stored, and I a therefor not interested in saving them just because excel 2003 wants m to. The file structure are the same in excel 2003 and Excel XP(which wa my earlier version) I am also not interested in turning all alerts off with the vba Application.DisplayAlerts = False because some alerts are ok to see. Is there a solution for this??  Please help :-- VBA_Newbi ----------------------------------------------------------------------- VBA_Newbie's Profile: http://www.excelforum.com/member.php...fo&userid=1479 View this thread: http://www.excelforum.com/showthread.php?threadid=26416 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VLOOKUP displaying "NO ANSWER" instead of "0" | Excel Worksheet Functions | |||
| How do I write an excel formula with a text answer ("yes" or "no") | Excel Discussion (Misc queries) | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
| Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
Threaded Mode
