How do you Print "Forms" Buttons?

K

Ken

Excel2003 ... I have a Worksheet with several Macro buttons (objects?)
created from "Forms" Tool bar ... They all work fine ...

Above said ... How do I set Excel to "Print" these object buttons when I
print the Worksheet.

Thanks ... Kha
 
D

Dave Peterson

Rightclick on each button
choose Format Control|Properties tab|Check Print Object
 
K

Ken

Dave ... (Good morning)

To many "buttons" to many WorkSheets ... I am trying to print a sample of
Worksheets from various files with "buttons displayed" so Users will have
idea of what will be required of them ...

Above said ... is there an easier way to print all "Form" buttons on a
Worksheet ... or must I select each button & select "Print object" as stated
in your original reply? Thanks ... Kha
 
D

Dave Peterson

You could use a macro:

Option Explicit
Sub testme()
Dim BTN As Button
Dim wks As Worksheet
For Each wks In ActiveWorkbook.Worksheets
For Each BTN In wks.Buttons
BTN.PrintObject = True
Next BTN
Next wks
End Sub

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm
 
Top