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

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



Ken wrote:

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

--

Dave Peterson

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

"Dave Peterson" wrote:

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



Ken wrote:

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

--

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




Ken wrote:

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

"Dave Peterson" wrote:

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



Ken wrote:

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

--

Dave Peterson


--

Dave Peterson