Keyboard shortcut challenge.

[Lythande]

Hey board,

I want to "print selection", but not have to CTRL+P and use the mouse to select print selction from the Settings menu--especially with printing selections off a 2000 line spreadsheet. This was no issue with my old Office version, but I just got Office 2010 so need to track down the keyboard shortcut.

Hint: before I only had to hit CTRL+P then ALT+N....none of this point and click stuff. Now ALT+N after CTRL+P opens up a template page. Doh!

 

[njimack]

You could assign the following line of code to a keyboard shortcut or icon on the QAT:

Selection.PrintOut Copies:=1, Collate:=True, IgnorePrintAreas:=False

 

[Lythande]

Ah...it stays selected once selected....okay, I can live with that.

 

[Scott Huish]

In XL2007, CTRL-P, then ALT-N still selects Print Selection