lock button position
 

I have assigned a macro to a text box on the sheet, the macro refreshe
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 th
sheet

--
niha
-----------------------------------------------------------------------
nihad's Profile: http://www.excelforum.com/member.php...fo&userid=3028
View this thread: http://www.excelforum.com/showthread.php?threadid=49952

lock button position
 

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