Actually there is at least one way. You can use the following macro OnActivate of each sheet:
Sub Zoom ActiveDocument.GetApplication.WaitForIdle ActiveDocument.ActiveSheet.FitZoomToWindowEnd Sub
Further functions and documentation may be found in the "API Guide.qvw" file under your C:\Program Files\QlikView\Documentation folder
Hope that helps.
Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4
To flush this out a bit more for people unfamiliar with macro:
Go to Tools -> Edit Module
Add Miguel's code at the bottom of the window:
Go to the sheet you want to auto resize and then go to Setting -> Sheet Properties
Select the "Triggers" tab
Click the "Add Action(s)..." button under OnActiveSheet
Select "External" from the left hand list and "Run Macro" from the right hand list. Click "OK"
Type "Zoom" under Macro Name
Click "OK" until you have exited all the windows.
This worked for me on one sheet. When I added the macro to the sheet properties of multiple sheets the user gets a pop-up saying:
"Macro parse failed. Functionality was lost"
The re-size works; but the sheet becomes very buggy and unusable.
Any Idea what is wrong?
UPDATE: The cause of my problem was that I was using the Qlikview IE plugin Version 7. This version allows the user to rename sheets. for some reason it doesnt work well with the macro. I uninstalled version 7 and reinstalled version 3. The Macro works fine now.