lock button position

  • Thread starter Thread starter nihad
  • Start date Start date
N

nihad

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

DREAM FEATURE: A macro that moves a row but asks me where to move it 18
form buttons on sheet collapse on unhide - sometimes 5
Button location problem 4
How to move worksheet into specific position? 3
Advice on multiple macros, same code just a different column 9
Excel Move or Copy Stopped Working? 0
Lock Button Position 1
Option Box on user from to update workbook 6

Back
Top