ActiveX Command Buttons - Dont stick in the same place?

Hi,

Anyone know much about how to get some command buttons to stick in one place?

I currently have two in a summary sheet. Each button runs a similar code which clears and deletes (by shifting cells upward) at the start of the process, then populates data.

It's rather annoying though that I cant have the buttons stick to one zone, they end up moving left or right depending on which button I press. Each report also changes column sizes, dont know if that's relevant?

Anyhow, thanks for the help! The code is below in case it helps too.

Please Login or Register  to view this content.

You probably need to place the buttons in an area that does not get affected by your column or row manipulation.