Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel macro for print dialog box only

Status
Not open for further replies.
MikiH

MikiH

Programmer
Sep 25, 2002
78
GB
Hi all

I've got a excel spreadsheet which I want to add a button / macro to open the print dialog window, I don't want to print the document just open the dialog box to select the printer. Any ideas??


Thanks
Mick
 
Sort by date Sort by votes
The Dialogs collection contains all built-in excel dialogs:

[tt]Application.Dialogs(xlDialogPrint).Show[/tt]

combo
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

PSchubert
  • Locked
  • Question
Excel: Formula only works with certain numerical values
Replies
12
Views
1K
dhookom
dhookom
techguy2010
  • Locked
  • Question
Excel macro to send e-mail to multiple agents with a different body for each 1
Replies
3
Views
749
techguy2010
techguy2010
Swi
  • Locked
  • Question
Excel Webservice
Replies
2
Views
537
mintjulep
M
Kennelbloke
  • Locked
  • Solved
Excel Unique-Filter issue
Replies
3
Views
485
SkipVought
S
bkoopers
  • Locked
  • Question
Problem with Excel pasting into filtered cells
Replies
1
Views
328
combo
combo

Part and Inventory Search

Sponsor

Back
Top