ExcelBanter - In excel macros remove by default message's of excel

Thanx it solved my problem .. Thanx a lot.

"Stefi" wrote:

The best way for this is to record a macro of clicking on the print button!
you will see something like this:

ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True

Regards,
Stefi

€žVijay Kotian€ ezt Ã*rta:

Similarly, while giving print order every time i need to click on print
button but with your suggestion it is not working out .. can you please help
me with print through program without clicking every time on print button.

Regards
Vijay Kotian

"Stefi" wrote:

Perhaps these samples will help you:

Sub test1()
RequiredAction = True 'got from the program
If RequiredAction Then
ActiveWorkbook.Save
Else
ActiveWorkbook.Saved = True 'let the file be closed without saving
and alerting for save
End If
End Sub
Sub test2()
RequiredAction = True 'got from the program
If RequiredAction Then
Application.DisplayAlerts = False 'overwrites the file without
warning
ActiveWorkbook.Save
Application.DisplayAlerts = True
End If
End Sub

Regards,
Stefi

€žVijay Kotian€ ezt Ã*rta:

In macros while saving or closing the file we are getting by default
messages from excel to €œsave the file€ or €œfile already exist€ etc How is it
possible to remove by providing €œYes€ or €œNo€ through program€¦ How is it
possible to do that?