Hi, I have an issue with command Button trying to change its position but not working. Please share Solution and also share that how we can drag the button with mouse.
Code to Move Command Button
- ArhamRajput
- Thread is marked as Resolved.
-
-
What have you tried that is not working?
-
Why do you want to drag the button?
Your sheet is protected so you cannot change the button's size
-
-
You want code to do it? Why?
-
I don't understand what you mean.
-
-
I don't know where you might have described what you want! You don't answer my question either - why do you want to move them? I think you expect to delete the roe based on the button's position, but I doubt if that will work.
-
Look at the buttons i have highlighted them they both are different in sizes and also in position i want to give sequence.
-
Are you reading my replies?
-
-
You haven't answered my questions about why you want to do this with code. I've told you to unprotect the sheet, also I assume that as you added the buttons then you know to amend them in Design Mode.
Just remember, I don't work for you and like everyone else answering questions it is voluntary
-
The buttons are ActiveX controls. You need to unprotect the sheet and click the Design Mode button in the Developer Tab of the Ribbon - itlooks like a set square and ruler. You can then move buttons or change their size.
For the code to work you have to switch off Design Mode when you have finished.
-
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!