Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is there any possible way to auto-resize objects on a sheet automatically? Use case is this: an application is designed to work with 1024x768 screen resolution as the least common denominator. A user with 1920x1200 resolution opens the app and maximizes their screen, and we want the pivot table on the screen to automatically resize to fill the empty space.
Thanks,
Gary
Have you considered using a macro like
ActiveDocument.ActiveSheet.FitZoomToWindow
linked with activate-sheet-event?
Peter