Macro Deletes Form Control Button

[mvparker79]

I have a macro that cleans up a report from our accounting system. I usually run this macro from my personal workbook as a button from my quick access toolbar. However, I need to put the macro in to a file that will be used by several team members. So I was thinking of adding a form button and pointing the form button to that macro. The problem is that part of the macro deletes some of the top rows and it is deleting the form button. I've tried moving it to an area that does not get deleted, but of course it will move the button up. I've also tried locking the spreadsheet, but of course, the macro can't run while the sheet is locked.

What should i do?

[nankw83]

I normally insert a square shape and assign the macro to it … Right click the shape & click format shape & from there under properties, select "Don't move or size with cells"

Edit : You can do the same thing with a form button, right click > Format Control > Properties > Don't move or size with cells

[mvparker79]

And that will prevent it from being deleted as well as moving or resizing?

[nankw83]

Yes, I just tired it in a sample file & it worked !

[mvparker79]

Oh it is so beautiful! lol Thank you!

[nankw83]

Glad to help … Please mark this thread as solved by selecting Thread Tools from the menu link above & add to the reputation(s) of those who helped