Spreadsheet print including macro buttons?

G

gunga

I am trying to print an Excel spreadsheet which includes macro buttons, but
the button does not appear in print.

Can anyone please help?
 
J

JulieD

Hi

if you created the button from the Forms toolbar then it won't - if you
create the button from either the control toolbox or a drawing object (both
which can be linked to macros) then they will

cheers
JulieD
 
D

Don Guillett

And if, like me, you don't lilke the control toolbox, just use a shape
instead. In properties you can choose to print/not
 
J

Jim Cone

Julie,

Actually, the command button from the Forms toolbar
will print if you Right-click, select Format Control and
checkmark "Print object " on the Properties tab.


Regards,
Jim Cone
San Francisco, USA
 
G

Gord Dibben

Julie

A button from the Forms Toolbar should print.

Right-click on it and Format Control>Properties>Checkmark "Print Object".

gunga should check this property on the buttons in question on the sheet.


Gord Dibben Excel MVP
 
Top