Text box macro button...need it to remain stationary.

[JC]

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!!!

 

[Andy Pope]

Hi,

Select the textbox. Right click and pick Size and Properties...
Set the object to not move or size with cells.

Cheers
Andy

 

[Bob Phillips]

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.

 

[JC]

Bob,
This worked!!! Exactly what I wanted it to do!!
Thanks for your help!!!