Spreadsheet print including macro buttons?

[Guest]

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

Can anyone please help?

 

[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

 

[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

 

[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

 

[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