lock button position

[nihad]

I have assigned a macro to a text box on the sheet, the macro refreshes data, inserts some columns and rows, which moves my text box around. How can i lock the position of the button to a certain spot on the sheet?

[Elkar]

Right-click your text-box and select "Format Text Box". (Make sure you
aren't editing the text box). Click on the "Properties" tab. Select the
option "Don't move or size with cells".

HTH,
Elkar


"nihad" wrote:

>
> I have assigned a macro to a text box on the sheet, the macro refreshes
> data, inserts some columns and rows, which moves my text box around.
> How can i lock the position of the button to a certain spot on the
> sheet?
>
>
> --
> nihad
> ------------------------------------------------------------------------
> nihad's Profile: http://www.excelforum.com/member.php...o&userid=30285
> View this thread: http://www.excelforum.com/showthread...hreadid=499526
>
>