Prevent Button from shrinking and being deleted with row

[RAFA_NADAL]

Hi,

I create a button (Copy) to call a VBA procedure:
Untitled.png

When i delete the row, where the button is located, the button shrink and disappear with the row.
Untitled1.png

Please show me how to keep the button from delete with the row when i delete the row.

[AliGW]

Did you attach the button to a particular cell?

As you have been told before, attach the workbook, NOT a picture of it!!!

[RAFA_NADAL]

I choose button from Form Control, Insert of Developer tab:
Untitled2.png
Then locate it on the screen:
Untitled3.png

[AliGW]

Why do you ignore my suggestions?

Will you please attach a sample Excel workbook? We are not able to work with or manipulate a picture of one and nobody wants to have to recreate your data from scratch.

1. Make sure that your sample data are REPRESENTATIVE of your real data. The use of unrepresentative data is very frustrating and can lead to long delays in reaching a solution.

2. Make sure that your desired results are also shown (mock up the results manually).

3. Make sure that all confidential data is removed or replaced with dummy data first (e.g. names, addresses, E-mails, etc.).

4. Try to avoid using merged cells as they cause lots of problems.

Unfortunately the attachment icon doesn't work at the moment, so to attach an Excel file you have to do the following: just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.

Please pay particular attention to point 2 (above): without an idea of your intended outcomes, it is often very difficult to offer appropriate advice.


Please don't quote whole posts, especially when you are responding to the one immediately preceding your own - it's just clutter. It's OK to quote if you are responding to a post out of sequence, but limit quoted content to a few relevant lines that makes clear to whom and what you are responding. Thanks!

For normal conversational replies, try using the QUICK REPLY box below.

[RAFA_NADAL]

Please check my file.
I am sorry that due to my boss's policy, I have chaged the letter in the file with XXXX.

[AliGW]

Well, obviously - which is why I said this in post #4:

3. Make sure that all confidential data is removed or replaced with dummy data first (e.g. names, addresses, E-mails, etc.).

Please do us the courtesy of reading our advice FULLY. If you don't understand any of it, just ask for clarification.

Hopefully someone who can help with this will be along soon.

[dotchiejack]

Why not using a shortcut to open the form? (for example Ctrl + Q in not used in excel)

[AliGW]

Or place the button above any data (and then freeze the top rows where it sits).

[jolivanes]

Right click on the Button, format control, properties and select "Don't move or size with cells."
Or hold down your Ctrl key while left clicking on your Button (to select it) and then run this code.

Sub No_Shrink_Button()
    With ActiveSheet.Shapes
    With Selection
        .Placement = xlFreeFloating
        .PrintObject = False
    End With
    End With
End Sub