Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
remove default data path for sql queries excel 2003? | Setting up and Configuration of Excel | |||
Remove all macros and objects in Excel, Save and Quit | Excel Programming | |||
How to remove excel macros still there after normal delete? | Excel Discussion (Misc queries) | |||
Remove excel macros from a file to be sent | Excel Programming | |||
where is the default directory of excel macros ? | Excel Discussion (Misc queries) |