I have an issue with the Active X buttons in my workbook.
Every time I click on those buttons, the button shifts to the left. I have locked the sheet. I have locked each button. I have changed the button property placement to 3. I have even tried Property placement 1. I have set all the button properties to "Don't move or size with cells".
Nothing works. No matter what I do, each time I press the button, the button shifts a bit to the left.
Is there a way where I can get the position of the button upon clicking it and then resetting the original position after running my code?
Thanks in advance.
Every time I click on those buttons, the button shifts to the left. I have locked the sheet. I have locked each button. I have changed the button property placement to 3. I have even tried Property placement 1. I have set all the button properties to "Don't move or size with cells".
Nothing works. No matter what I do, each time I press the button, the button shifts a bit to the left.
Is there a way where I can get the position of the button upon clicking it and then resetting the original position after running my code?
Thanks in advance.