Space for Macro Buttons

[Colmans]

Hi

I have a worksheet with a data I need to manage. Row 1 contains the data headings which is filtered.

I have created a couple of Macros which I want to use in the worksheet and need to create some space at the top of the workskeet for them to sit, along with some other text in a text box. I have a work round by inserting a new row 1 and merging all the cells and putting my macros and text box here. However, as one of my macros hides some columns, the buttons move around when the worksheet layout changes.

Is there something I can do to either stop this, or is there an alternative option to solve this?

Thanks in advance for your assistance.

 

[mumps]

I assume that the buttons are shapes that you inserted. If so, right click the shape. Then click 'Format Shape' ..... 'Properties' ....... 'Don't move or size with cells' ..... 'Close'

 

[mole999]

right click on the button and set the option / properties

you could also make row 1 slightly bigger, and align the headings across the bottom

 

[Colmans]

I assume that the buttons are shapes that you inserted. If so, right click the shape. Then click 'Format Shape' ..... 'Properties' ....... 'Don't move or size with cells' ..... 'Close'

I have used Active X tick boxes for the layout options. I can only access the properties via the developer, and the options stated above do not show

 

[Colmans]

Ok - I found it - it's in Properties within the "Format Control" option

Thanks for your help

 

[mumps]

You are very welcome.