Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
prompt to save when already saved
you need
application.displayalerts = false at the beginning of your code, and turn it back on again with "true" at the end of your code. :) susan On Feb 2, 3:33*pm, Scooter wrote: I have a macro in a blank workbook that opens, updates and closes other workbooks. * *The below 3 lines are what I repeat for the files to update. * Why do I still get the "Do you want to save your changes..." prompt when it closes a file? * * Workbooks.Open Filename:="aaa.xls", UpdateLinks:=True * * Workbooks("aaa.xls").Save * * Workbooks("aaa.xls").Close |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
prompt to save when already saved | Excel Programming | |||
Prompt for saving a saved workbook | Excel Programming | |||
prompt user to save file as {desired_name} and save it to a variab | Excel Programming | |||
save prompt for user exit, but no save prompt for batch import? | Excel Discussion (Misc queries) | |||
internet explorer (ie) issue with activeworkbook.saved (save prompt) AAARGH. | Excel Programming |