Floating button

[Excelski]

Hi,

Can someone help please with code that will keep my macro button at a given distance from the left side of the worksheet when scrolling left and right

Thanks
Kevin

[dominicb]

Good morning Excelski

Something like this should work, just be aware that you will lose your Undo functionality. There's no simple way around this so choose whether you want Undo or a floating Command Button.

Please Login or Register  to view this content.

HTH

DominicB

[Excelski]

Good morning Dominic,

Many thanks, works great.

Can it be adapted to use an icon as the button

Thanks
Kevin

[dominicb]

Hi Excelski

What do you mean by an icon? You want to place a picture inside the button?

If so, then you can do that by setting the Picture property in the Command Button Properties window. However, be aware that all ActiveX controls use a very limited colour palette so the chances are, the images won't look great.

HTH

DominicB

[Excelski]

I wanted to use one of the built-in icons in 365.....I've worked out how to insert a picture but not an icon

[dominicb]

Hi Excelski

I think you're just going to have to grab the icon as a bitmap to place it onto the Command Button as an image.

HTH

DominicB

[Excelski]

Thanks for your help Dominic