Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default 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?


  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4,391
Default 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?




  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default 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?





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Print dialog box selection macro I think I need to rephrase the question Excel Discussion (Misc queries) 2 November 4th 07 11:31 PM
printing multiple print areas with a print dialog box LHaro Excel Programming 0 August 17th 05 09:56 PM
control of dialog macro dialog box. on open Gerry Abbott Excel Programming 0 July 22nd 04 05:41 PM
Print dialog MN Excel Programming 3 August 26th 03 04:06 AM
Hiding print dialog box within macro Annie[_2_] Excel Programming 0 August 24th 03 02:26 PM


All times are GMT +1. The time now is 02:48 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"