ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Macro for Ctrl-P to print (https://www.excelbanter.com/excel-programming/339917-macro-ctrl-p-print.html)

JasonSelf[_17_]

Macro for Ctrl-P to print
 

I am trying to create a macro that brings up the print manager you ge
when pressing ctrl-p in excell. I do not know how to reference thes
types of items with vba and would appreciate the guidance

--
JasonSel
-----------------------------------------------------------------------
JasonSelf's Profile: http://www.excelforum.com/member.php...nfo&userid=533
View this thread: http://www.excelforum.com/showthread.php?threadid=46709


JasonSelf[_18_]

Macro for Ctrl-P to print
 

I changed the keywords I searched on the forum and found the answer

application.Dialogs(xlDialogPrint).Show

Thank

--
JasonSel
-----------------------------------------------------------------------
JasonSelf's Profile: http://www.excelforum.com/member.php...nfo&userid=533
View this thread: http://www.excelforum.com/showthread.php?threadid=46709



All times are GMT +1. The time now is 03:26 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com