Command Buttons Not Copying to the Designated Cell

[Ataraxicatom]

Hello,

I have a command button set up to gather information, then create a new sheet, and paste a copied button from another location to the new sheet. The command button that shows up on the new sheet is offset and not centered in the cell. It is centered in the cell where it comes from and the cells are the same size.

I noticed that if I copy a command button and simply paste it to a new sheet, it is offset just like this. I need it to not do this. If I have to make it write in a new command button and assign a macro to it, that is fine. I went with the copy/paste option to save time. I am wondering if this is possible.

Code Incoming:

Please Login or Register  to view this content.

Now, before it becomes an issue, this is only a part of the full code, but it is running in it's own conditional loop. The other part works fine. And I tried changing the alignment in the cell to see if that was the issue. It was not. =(

Issue: Copied command buttons are offset in the cells they are pasted to.

[Ataraxicatom]

I never did find out how to get the copy function to paste without the offset. Instead, I just had it write a new button when it was necessary.