ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How do i get the print dialog box to appear in a macro? Help!!! (https://www.excelbanter.com/excel-programming/338933-how-do-i-get-print-dialog-box-appear-macro-help.html)

smithers2002

How do i get the print dialog box to appear in a macro? Help!!!
 
I have a designed a report in ppt which i would like people to be able to
print from presentation show mode (ie- cant edit the data). Is there anyway
of designing a macro which will open up the print dialog box (so people can
choose colour/b&w print), but not actually print to the default?



NickHK

How do i get the print dialog box to appear in a macro? Help!!!
 
smithers,
Probably better to ask in a PowerPoint group.

NickHK

"smithers2002" wrote in message
...
I have a designed a report in ppt which i would like people to be able to
print from presentation show mode (ie- cant edit the data). Is there

anyway
of designing a macro which will open up the print dialog box (so people

can
choose colour/b&w print), but not actually print to the default?





smithers2002

How do i get the print dialog box to appear in a macro? Help!!
 
Its more to do with VBA than power point though, so thought Excel users would
be better people to ask.

"NickHK" wrote:

smithers,
Probably better to ask in a PowerPoint group.

NickHK

"smithers2002" wrote in message
...
I have a designed a report in ppt which i would like people to be able to
print from presentation show mode (ie- cant edit the data). Is there

anyway
of designing a macro which will open up the print dialog box (so people

can
choose colour/b&w print), but not actually print to the default?







All times are GMT +1. The time now is 06:39 AM.

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