how to freeze a cell?

[vengatvj]

i want freeze only one cell. Is it possible or not? I have a button. I want keep that button permanently in a place. i am planning to freeze a cell where the button is located.

any ideas or suggestion tell me.

[Pete_UK]

If you apply Freeze panes, it will lock the top-most row(s) and/or the left-most column(s) - can you not position your button at the top or to the left of your sheet?

Hope this helps.

Pete

[vengatvj]

Ya I know that. My macro button went to left side when i am scrolling towards right side row.

[Winon]

Hello vegatvj,

If it is a Forms Button and not an Active X Button, you may right click on the Button, then click on the outline> Format Control>Properties, and then Check the box "Don't move or size with Cells".

Regards