Description

This article is from the Spreadsheets FAQ, by Russell Schulz casfaq@locutus.ofB.ORG with numerous contributions by others.

10.2 How can I do a Save-As or Exit without prompting the user? (spreadsheets: Excel)

VBA:

You can suppress the messages with:
Application.DisplayAlerts = False

Don't forget to turn them back on when you are finished with:
Application.DisplayAlerts = True

10.3 How do I put multiline text string in a message box? (spreadsheets: Excel)

VBA:

MsgBox _
"This will print on line one" & Chr(13) & _
"this will print on line two"

 

Continue to:

• prev: 10.0 Excel history
• Index
• next: 10.4 Why do I get "File format no longer supported"? (spreadsheets: Excel)

Share and Enjoy

Tags

business, spreadsheets, Excel, Quattro, Lotus 1-2-3, free, open source, commercial, tab delimited, csv, formula, macro