Print Button help

  • Thread starter Thread starter -Brian-H-
  • Start date Start date
B

-Brian-H-

can I create a print button for my workbook that would open a smal
form and let the user select which sheets and how many copies? O
would I be better off linking the button to the windows print scree
for the user to make a choice?


2ndly, how do you set the buttons to "visible only on screen" like yo
can in Access? (so they don't print) Thank Yo
 
Brian

Yes, you can create a print button and use code such as can be found at John
Walkenbach's site. It does not allow designating number of copies, but I'm
sure you could alter that.

http://j-walk.com/ss/excel/tips/tip48.htm

OR teach the users to just select sheet tabs by CRTL + Click then go through
the Excel print dialog.

Buttons and other objects have properties that can be set to "not print".

Right-Click on the button and Format>Properties> uncheck "Print Object"

Gord Dibben Excel MVP
 
Back
Top