Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Fileprint

  Asked By: Matilda    Date: Feb 08    Category: MS Office    Views: 659
  

Hey people i would like to know a way that i can assign a macro to file
print and not bu customizing the buttonbut i would rather itredirect is
self to the macro throught VBA

Share: 

 

1 Answer Found

 
Answer #1    Answered By: Ramon Davis     Answered On: Feb 08

The sub you would want to modify is FilePrintDefault. You can find
most of the default commands through the Word and modify
appropriately for Excel. Search for "Modifying a Word Command" in
the Word VBA Editor.

Sub FilePrintDefault()
'
' FilePrintDefault Macro
' Prints the active document using the current defaults
'
ActiveSheet.PrintPreview

End Sub

 
Didn't find what you were looking for? Find more on Fileprint Or get search suggestion and latest updates.

Related Topics:



Tagged:  

 

Related Post