I'm using command buttons for process control in a spreadsheet. Using vba to enable and disable buttons to keep the user moving along. Each button performs a different vba routine.
Problem I'm having is the buttons resizing themselves with each click. Specifically increasing in size, but the button dimensions remain locked. It's like looking through a window and zooming in more with each click.
I can go into Developer/Design Mode and manually resize the buttons by dragging them out bigger and then returning them to their original size. But when out of Design Mode, the same thing occurs.
Some older posts suggest the problem is with screen resolution - on my workstation monitor it works fine, but unlocking my laptop and using that screen, the problem occurs. So I tried setting monitor and screen to same resolution - but doesn't help.
Various other web remedies havent worked either. Majority of posts on the web are so old, I can't believe this hasn't been fixed - solution found.
Anyway, I could use form control buttons, but I really like being able to help the user through the process by turning on and off command buttons.
Can anyone tell me what's happening to my buttons and how to stop it.
Problem I'm having is the buttons resizing themselves with each click. Specifically increasing in size, but the button dimensions remain locked. It's like looking through a window and zooming in more with each click.
I can go into Developer/Design Mode and manually resize the buttons by dragging them out bigger and then returning them to their original size. But when out of Design Mode, the same thing occurs.
Some older posts suggest the problem is with screen resolution - on my workstation monitor it works fine, but unlocking my laptop and using that screen, the problem occurs. So I tried setting monitor and screen to same resolution - but doesn't help.
Various other web remedies havent worked either. Majority of posts on the web are so old, I can't believe this hasn't been fixed - solution found.
Anyway, I could use form control buttons, but I really like being able to help the user through the process by turning on and off command buttons.
Can anyone tell me what's happening to my buttons and how to stop it.