gallen
Well-known Member
- Joined
- Jun 27, 2011
- Messages
- 2,016
I did a presentation yesterday demonstrating a spreadsheet I have designed. It works perfectly on my widescreen monitor. Unfortunately, the presentation had to be done on a projector and the best aspect ratio was 4:3 not 16:9.
At first this didn't pose much of an issue as I have code to automatically zoom to fit the screen, whatever resolution you are using. However in time the active x controls started appearing in different places as I clicked off the sheet and then back on to it. On my widescreen monitor I have no issue with this.
I have all my controls set to 'Don't move or size with cells'. Is this wrong?
At first this didn't pose much of an issue as I have code to automatically zoom to fit the screen, whatever resolution you are using. However in time the active x controls started appearing in different places as I clicked off the sheet and then back on to it. On my widescreen monitor I have no issue with this.
I have all my controls set to 'Don't move or size with cells'. Is this wrong?
