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

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

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

Hi,

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

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"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!!!

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

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

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

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

"Bob Phillips" wrote:

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