Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 249
  • Last Modified:

VBA to send keys

Hello Gurus,

Because users are not very good with print options and how to print :(
I am simply creating a PRINT button in excel sheet that prints out the activehsset - how do i create a macro in vba that prints out the activehsheet?
0
Rayne
Asked:
Rayne
1 Solution
 
Naresh PatelTraderCommented:
just record a macro.
0
 
MacroShadowCommented:
Sub PrintActiveSheet
     ActiveSheet.PrintOut
End Sub

Open in new window

0
 
RayneAuthor Commented:
thank you all
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now