HOW TO NOT PASTE A COMMAND BUTTON

[Mr_Phil]

I just got a new windows 11 laptop and the office 365 subscription is in effect. Using Excel. I have a command button in the midst of a column header. From time to time I will copy the column headers and the first couple of (usually filtered) rows to send for action. My command button also copies and pastes into outlook which really "enhances" the look. In my old windows 10 / office 365 setup this did not happen. Is there a setting I might have triggered when migrating?

This is how it looks in the workbook (I have the xl2bb but the row limit got me and the data doesn't matter on this question)

This is how it looks when pasting into an email. That button causes outlook to make a nested table. Deleting the button in the email doesn't do anything for the look of the email being sent. Is there another properties sheet other than the one you get with a right click on the button?

 

[Micron]

Did you try setting the PrintObject property to False?
How are you getting that into the email - if I copy cells I don't get any buttons when pasting into Outlook email?

 

[Mr_Phil]

Did you try setting the PrintObject property to False?
How are you getting that into the email - if I copy cells I don't get any buttons when pasting into Outlook email?

I have no idea why the command button copies over to outlook. It's inert and easily deleted. Then the table has to be fixed. AS you mentioned (thank you for trying to help btw) I checked and then unchecked the print object checkbox for the button so it should be set at false. The Move and size properties have been back and forth trying to see if they are influencing the copy/paste behavior.

 

[Mr_Phil]

Did you try setting the PrintObject property to False?
How are you getting that into the email - if I copy cells I don't get any buttons when pasting into Outlook email?

Hi again. I figured it out and wanted to at least tell the guy that tried to help me. It is in the settings.

FILE>OPTIONS>ADVANCED>CUT COPY PASTE> UNCHECK THE THIRD BOX as shown.

 

[Micron]

Hmm. As I wrote, that didn't happen to me even though that setting is checked in my version. Maybe something to do with how the object is placed in your sheet since we both seem to have the same version ( or do we? 365, version 2205)

 

[Mr_Phil]

Hmm. As I wrote, that didn't happen to me even though that setting is checked in my version. Maybe something to do with how the object is placed in your sheet since we both seem to have the same version ( or do we? 365, version 2205)

Yes we are close. Mine is version 2209