How to auto activate Fit zoom To windows

[paulyeo11]

Hi All

i need to automatic turn on Fit zoom to windows when i go to every sheet. can some one tell me how to do it ?

it is possiblw to do it with out macro ?

Paul

[#2]

Yes it is possible

Try this macro, and fire it with a trigger on the opening of your sheet

sub fit
ActiveDocument.ActiveSheet.FitZoomToWindow
end sub

[rustyfishbones]

Hi,

You can check out this video on Youtube

Qlikview Zoom to Fit Macro by RFB 96

http://youtu.be/BN5prtvCVE0

[paulyeo11]

Hi All

I try button it work fine. But when i try to go to sheet properity to set trigger event when turn on sheet , it does not work. i also read from other post , it also reported it have bug on it , i am using ver 9. hope some one can confirm on this.

[#5 · Accepted solution]

Hi

I have a V9 installed on my computer and it works for me.

Please check you QV release : mine is SR7

[paulyeo11]

Hi Sir

Thank you , i know why ne ot working ,as i am not activate sheet using tab , i use button and it does not work.

Paul

[#7]

Well it works for me even when I use a button to activate the sheet.

If it dosnt for you, you can fire the macro in the actions of the button !

[paulyeo11]

Hi Sir

I have enclosed my sample doc , which is having problem , when i try to run macro on zoom using button. Hope you can take a look.

[#9]

I have difficulities to understand your app

but it seams to work on my qv 9

[paulyeo11]

it is okay , i think i  to live with it , may be later i should be able to figure out .