Macro help

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Application.Displayalerts will prevent these kinds of messages from popping
up and will "usually" take the action desired.
 
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
(e-mail address removed)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA / Macro Help Please 2
Selecting all cells with content using a variable 3
Data Validation List Macro 18
Select drop down menu option using libre-calc macro 0
macros 3
Macro Help 1
Assign a macro to the save button 4
Macro Query 1

Back
Top