Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Changiing defaults in VBA
Can anyone help me with this one - I need a code that
over writes the defaults when saving a document. For example, when opening a workbook from one location and saving into a different location with a file with the same name, I need it to save without the "This file already exists, do you want to replace the existing file?" The default is set to NO, but I need it to be YES Many thanks in advance John |
#2
|
|||
|
|||
Precede with
Application.DisplayAlerts = False and reset afterwards. -- HTH RP (remove nothere from the email address if mailing direct) "JohnUK" wrote in message ... Can anyone help me with this one - I need a code that over writes the defaults when saving a document. For example, when opening a workbook from one location and saving into a different location with a file with the same name, I need it to save without the "This file already exists, do you want to replace the existing file?" The default is set to NO, but I need it to be YES Many thanks in advance John |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Text import wizard defaults? | Excel Discussion (Misc queries) | |||
excel defaults "i" to upper case | Excel Discussion (Misc queries) | |||
Change Margin Defaults | Setting up and Configuration of Excel | |||
Can you change the defaults for Excel |
Excel Discussion (Misc queries) | |||
Footer defaults | Excel Discussion (Misc queries) |