Help? I created my VBA script and assigned the macro's to some command buttons.
Strangely the first button keeps its place after running the assigned macro as it should do, but the next two buttons keep moving on the sheet after each assigned macro-run.??
How is this possible?
So button1 stays in place and 2 and 3 move sidewards after running script.
Make my day
Move and size with cells is enabled on all 3 buttons! Settings are same in designmode ?
Last edited by Harrij; 08-16-2014 at 08:19 AM.
I had a similar issue with a macro I use I was deleting columns after I did some sorting the work around I used was just to add extra columns so as when the macro had finished the buttons where in the same spot I turned off the screen update whilst the macro worked so as this couldnt be seen. Might this help you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks