TimvMechelen
Board Regular
- Joined
- Nov 7, 2016
- Messages
- 121
Hi all,
When I activate a sheet I want excel to do the following process:
I want this because my file has to open on different screens/screen resolutions and everything has to be visible.
I hope somebody can help me.
When I activate a sheet I want excel to do the following process:
Is cell "Z1" in the range of my screen?
Yes:
Do nothing
No:
Code:Range("A1:Z1").Select ActiveWindow.Zoom = True
I want this because my file has to open on different screens/screen resolutions and everything has to be visible.
I hope somebody can help me.