How to anchor a button?

[DavidZee]

Dear Experts,

I have a button that I would like anchored to cell G6. If I hide rows G5:G12, then save and exit Excel, the button gets moved to cell G13 the next time I open the file and unhide the perviously hidden rows.

It would be nice if there is a easy way to make the button stick to G6 so when I open and unhide the previously hidden rows, the button is position correctly in G6.

Much thanks,
DavZ

 

[Ekim]

Button from the Forms menu?

Place the button over cell G6.
Right click the button and select Format Control | Properties tab.
Click the radio button for “Don’t move or size with cells”
OK.