InOverMyH3ad
New Member
- Joined
- Sep 17, 2018
- Messages
- 13
- Office Version
- 365
- Platform
- Windows
Hello,
I am currently fighting with the annoying command button/checkbox resizing issue. I put code in that, when clicked, moves the object 1 pixel and then back 1 pixel which has seemed to help the resizing issue during use. However, we are still coming across the issue where the workbook is saved and all the command buttons are where they should be, but when the work book is opened, everything has shrunk.
I'm tired of dealing with this. Is it practical to have code with fixed values for each button that executes as soon as the workbook opens to make sure their initial size and position is correct? I'm open to other suggestions if there is a better approach!
I am currently fighting with the annoying command button/checkbox resizing issue. I put code in that, when clicked, moves the object 1 pixel and then back 1 pixel which has seemed to help the resizing issue during use. However, we are still coming across the issue where the workbook is saved and all the command buttons are where they should be, but when the work book is opened, everything has shrunk.
I'm tired of dealing with this. Is it practical to have code with fixed values for each button that executes as soon as the workbook opens to make sure their initial size and position is correct? I'm open to other suggestions if there is a better approach!