Do not print or save

[MGumbrell]

I have a ComandButton1 on Sheet6.

How can I still keep it visible when in use but when Sheet6 is printed and or saved as, ComandButton1 does not print, and/or saved as.

The user may save the workbook as another filename (Save As) or print the worksheet at anytime. I would only like ComandButton1 visible in the active sheet.

I trust that this makes sense.

Regards, Matt

 

[chergh]

Sorry doesn't make any sense to me.

 

[PaulJR]

I think you mean you want the button on the screen, but you don't want it on your printout.

Right click the command button, go to properties, select the Categorised tab, and change PrintObject to False.

I hope that is what your looking for.

 

[MGumbrell]

It is. Thank you