If you select the textbox and right-click it, there is a Size and Properties
option. Click the properties tab, and check Don't move and size with cells.

--
__________________________________
HTH

Bob

"JC" wrote in message
...
I'm using Excel 2007...I have a text box that has a macro assigned to
it..part of the macro states that it needs to delete Columns A:E, when
this
happens, the "macro button" shifts to the left after the macro has
run...is
there any way to make that text box stationary? So it won't shift when
the
columns are deleted? I can't add the macro button to my toolbar b/c this
sheet is shared with others, and they won't know to add it to their
toolbar...My people, need to run this macro from the same sheet multiple
times...so sooner or later, the button will be deleted...any suggestions
would be great!!!

Thanks in advance!!!