Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 36
Default Open print dialogue box when click on print icon in tool bar

On selected worksheets, when the print icon is selected in the toobar, I need the print dialogue box to show instead of the entire worksheet printing. Can you offer a macro? Thanks.
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,514
Default Open print dialogue box when click on print icon in tool bar

used his keyboard to write :
On selected worksheets, when the print icon is selected in the toobar, I need
the print dialogue box to show instead of the entire worksheet printing. Can
you offer a macro? Thanks.


Why can't you use the *Print...* menu to open the dialog?

--
Garry

Free usenet access at
http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion


  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 36
Default Open print dialogue box when click on print icon in tool bar

When I select the print menu, it automatically prints all the pages that I have in the worksheet. I am wanting to be able to select a range by using the print dialogue box.
  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 36
Default Open print dialogue box when click on print icon in tool bar

I'm using Excel 2003.


  #6   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,514
Default Open print dialogue box when click on print icon in tool bar

submitted this idea :
I'm using Excel 2003.


FilePrint... opens the dialog. Also, Ctrl+P.

--
Garry

Free usenet access at
http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion


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
what is print to file in print dialogue box and its useage? Vandana Excel Worksheet Functions 0 August 23rd 06 11:45 AM
Print Preview icon behaves like Print Jean Excel Worksheet Functions 1 July 7th 06 02:15 AM
code for print dialogue BorisS Excel Programming 2 June 18th 06 12:23 PM
How do I right-click print from Open documents list? Excel Short Cut Printing Excel Discussion (Misc queries) 0 April 18th 05 07:51 PM
how can I add a print dialogue? Rob Excel Programming 2 February 5th 05 10:11 PM


All times are GMT +1. The time now is 05:07 AM.

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"