How not to move ComboBox (activex control)
How can I have my combobox not move with cells. I have a code to hide columns. Inside the columns there is a combobox. When I try to hide the columns excel will not allow me to just hide the columns without moving the combobox. Don't move and don't size with cell does not work.
Code has a combobox located in column b and i want to hide column e and d leaving the combobox which is location in column e not to move
Hello marky000,
Welcome to the Forum.
Somewhere something does not sound right. Active X Controls do not normally "dissappear" when Columns are hidden. Maybe you have Form Buttons which are just not properly addressed in the Format Control.
Why not upload a sample WorkBook with the problematic Sheet?
Please consider:
Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .
You could use a code to move the button when you hide the column
and then move it back again when you unhide the column
Please Login or Register to view this content.
Hope this helps, otherwise i dont understand what you mean.Please Login or Register to view this content.
Sean
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks