Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
'ALT' + P for print preview
How can I make a keyboard shortcut to get to the print preview screen by
pressing ALT + P? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
'ALT' + P for print preview
You'd need to create a routine that does a print preview and create/run
another to make Alt-p run it. Sub AltP() ActiveSheet.PrintPreview End Sub ''Run this from Auto_Open or whenever you want Alt-p to do a preview Sub TrapAltP() Application.OnKey "%p", "AltP" End Sub Sub ReleaseAltP() Application.OnKey "%p" End Sub -- Jim "Ben" wrote in message ... | How can I make a keyboard shortcut to get to the print preview screen by | pressing ALT + P? | | |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
print preview v page break preview | Excel Discussion (Misc queries) | |||
After File Open View Preview get error message | Excel Discussion (Misc queries) | |||
print preview | Excel Worksheet Functions | |||
Removing Page Break Preview from all spreadsheets | Excel Discussion (Misc queries) | |||
XL print preview should show grayscale if chosen on color printer | Excel Discussion (Misc queries) |