Hello everyone
The only problem I currently have is with my command buttons. I size and position them as desired and chose the 'Don't move or size with cells'.
However when I save and then reopen them I find them well off the screen and 10 times bigger. I've searched numerous forums on the internet and no one has a 100% workaround.
Has anyone got any suggestions?
Thanks in advance
Are you using ActiveX or form buttons? If ActiveX, this has been an issue for a while now. ActiveX buttons are usually not the best choice, go with form buttons. Here is a link that might have a Hotfix for you...
http://www.excelforum.com/excel-prog...and-sizes.html
There was also this post in a much older thread that might help...
Thanks for the quick reply. That solved the problem. I also found a
workaround for the issues. Under the "Format Control | Properties" page for
the control, select the "Move and size with cells" rather than the defautl
"Move but don't size with cells."
1N73LL1G3NC3 15 7H3 4B1L17Y 70 4D4P7 70 CH4NG3 - 573PH3N H4WK1NG
You don't have to add Rep if I have helped you out (but it would be nice), but please mark the thread as SOLVED if your issue is resolved.
Tom
Thanks Tom
They are Form Buttons and the fix above didn't work unfortunately.
Any other ideas please?
Hmm.....That's all I know. Several people have had the problem, but it's usually related to using ActiveX buttons.....Not sure where to go from here...sorry.
Have you considered using shapes instead of buttons? I'm not sure if they suffer from the same resizing issue you are having, but if they do it is straightforward to delete and put them back on in VBA.
The code below might help if you think the approach would be useful for you:
Please Login or Register to view this content.
Last edited by mgs73; 11-23-2015 at 11:43 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks