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

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.
 
G

GS

(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.

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
 
M

michaelrlanier

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.
 
G

GS

(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.

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top