Anchoring bottons

[Dale Bennett]

Hey All,

How do you anchor an assigned macro button so it does not move when you scroll down or across the sheet? I want it to be in the same location no matter where the active cell is posion.

Dale

 

[shades]

How did you make the button? Forms toolbar, Control Toolbox toolbar?

 

[Dale Bennett]

Using "button" from the Forms toolbar

Dale

 

[Oaktree]

Dale:

The easiest way is probably to put your button at the top left of your file and use window --> freeze panes.