I'm running Excel 2003 and have created a few macros in a spreadsheet which
are run by clicking on a button. The macros work great, but when I print out
the spreadsheet, the titles on the buttons are not there - just blank space.
I have other spreadsheets where I've done this and the titles have printed
out, but I can't remember what I did, and a side by side comparison is coming
with nothing. Anyone here have some pointers?

Thanks!

The buttons won't print?

Right-click on a button and Format ControlProperties.

Check "Print Object"


Gord Dibben MS Excel MVP

On Fri, 12 Dec 2008 08:16:02 -0800, Michele
wrote:

I'm running Excel 2003 and have created a few macros in a spreadsheet which
are run by clicking on a button. The macros work great, but when I print out
the spreadsheet, the titles on the buttons are not there - just blank space.
I have other spreadsheets where I've done this and the titles have printed
out, but I can't remember what I did, and a side by side comparison is coming
with nothing. Anyone here have some pointers?

Thanks!

Thank you! That was what I was looking for.

"Gord Dibben" wrote:

The buttons won't print?

Right-click on a button and Format ControlProperties.

Check "Print Object"


Gord Dibben MS Excel MVP

On Fri, 12 Dec 2008 08:16:02 -0800, Michele
wrote:

I'm running Excel 2003 and have created a few macros in a spreadsheet which
are run by clicking on a button. The macros work great, but when I print out
the spreadsheet, the titles on the buttons are not there - just blank space.
I have other spreadsheets where I've done this and the titles have printed
out, but I can't remember what I did, and a side by side comparison is coming
with nothing. Anyone here have some pointers?

Thanks!