| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I undo the scroll lock, thscroll lock button does not work | Excel Discussion (Misc queries) | |||
| How can I lock the position of a textbox? | Excel Discussion (Misc queries) | |||
| How do I lock a combo box's position once it is placed? | Excel Programming | |||
| Lock userform position | Excel Programming | |||
| freeze/lock form position | Excel Programming | |||
Linear Mode
