Open print dialogue box when click on print icon in tool bar

  • Thread starter Thread starter michaelrlanier
  • Start date Start date
M

michaelrlanier

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.
 
(e-mail address removed) 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.
Click to expand...

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
 
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.
 
(e-mail address removed) explained on 30/10/2012 :
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.
Click to expand...

What version of Excel are you using that the *Print...* menu doesn't
open a dialog. (That's what the ellipses after the word *Print*
indicate)

Note that a menu is *NOT* an icon!

--
Garry

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