Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
I have a macro that does certain functions on startup of my worksheet, during
startup it collects info from a main file then pastes that info into the worksheet. I was wondering if there is a line of code that selects yes when the message box comes up and asks if you would like to 'replace the contents of the desination cells'. Also is there a line of code that will select no when it asks if you would like to save the large amount of information on the clipboard. |
#2
![]() |
|||
|
|||
![]()
Andy
Application.DisplayAlerts = False Turn them back on before code exits If you still get the clipboard one then you could try Application.CutCopyMode = False or copy a blank cell Range("A65536").Copy -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England HIS "andy" wrote in message ... I have a macro that does certain functions on startup of my worksheet, during startup it collects info from a main file then pastes that info into the worksheet. I was wondering if there is a line of code that selects yes when the message box comes up and asks if you would like to 'replace the contents of the desination cells'. Also is there a line of code that will select no when it asks if you would like to save the large amount of information on the clipboard. |
#3
![]() |
|||
|
|||
![]()
Application.Displayalerts will prevent these kinds of messages from popping
up and will "usually" take the action desired. "andy" wrote in message ... I have a macro that does certain functions on startup of my worksheet, during startup it collects info from a main file then pastes that info into the worksheet. I was wondering if there is a line of code that selects yes when the message box comes up and asks if you would like to 'replace the contents of the desination cells'. Also is there a line of code that will select no when it asks if you would like to save the large amount of information on the clipboard. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Macro - - Automation | Excel Discussion (Misc queries) | |||
Record Macro Relative does not work? | Excel Discussion (Misc queries) | |||
Record Macro Relative does not work? | Excel Discussion (Misc queries) | |||
excel macro inconsistency | Excel Discussion (Misc queries) | |||
Macro and If Statement | Excel Discussion (Misc queries) |