Printing Worksheet that shows macro buttons

[Cammandk]

I'm designing the layout of my worksheet and it has a number of VBA macro buttons on.
When I print the worksheet they don't appear on the printout.
Is this possible to achieve - can't find where to make happen

Thanks
david

 

[Xiq]

Try this:

1. Right click on the button > Format Control
2. Tab-"Properties"
3. Check the box "Print object"

 

[Cammandk]

Thank you Xiq
So easy when you know where to look [Solved]

 

[SirJB7]

Hi, Cammandk!
By default the Forms controls (top part of the Insert Controls toolbox) are set to don't be printed and the ActiveX controls (bottom part) are set to be printed.
The 1st ones aren't updated since more than 10 years and I think they're still there because of compatibility issues, the last ones are more functional and easy to handle, just fyi.
Regards!

 

[Cammandk]

Hi SirJB7

So should I be using ActiveX buttons instead of form control as the default.

Thanks
C.

 

[NARAYANK991]

Hi David ,

You can read what others have to say on this subject here :

1. http://dailydoseofexcel.com/archives/2004/08/11/controls-activex-vs-forms/

2. http://www.jkp-ads.com/Articles/controls02.asp

3. http://peltiertech.com/WordPress/forms-controls-and-activex-controls-in-excel/

Narayan

 

[SirJB7]

Hi, Cammandk!
If you ask me, I stopped using Form controls many years ago and as an advanced user I've never experienced the buggy behavior mentioned in the 1st article (which BTW is almost 10 years old, Excel has changed a bit since then) nor the file corruptions of the 2nd one.
Regards!