Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Need to adjust QV application automaticaly thts it must be fit to screen if we change it diff system. There is an option in QlikView to autoadjust to screen size.
Thanks in Advance.
Regards,
Srividhya. S
in addition you can add ... the below
Sub Zoom
rem ** fit active sheet to window and apply same zoom to all sheets **
ActiveDocument.ActiveSheet.FitZoomToWindow
ActiveDocument.GetApplication.WaitforIdle
ActiveDocument.ActiveSheet.ApplyZoomToAllSheets
End Sub
and do macro OnOpen and it should go for all Sheets ..
if you facing a prablom jest make a botton on the first sheet thet make this macro
hi srividhya,
You can call the below code on sheet activate
ActiveDocument.ActiveSheet.FitZoomToWindow
Hi deepak,
Thanks for ur reply.
Kindly provide step by step bcoz am new to QV.
Thanks again.
Regards,
Sri
Hi Srividhya,
Ctr+ M for Module editor.
Sub Test
ActiveDocument.ActiveSheet.FitZoomToWindow
end Sub
(Do the below step for 2-3 sheets and check if it helps you out.)
Now go to Sheet properties -> Trigger tab.
Add Action to OnActivateSheet. In Action Type select External --> Run Macro and In Macro Name give Test.
Hi Deepak,
Thanks Alot Yar 🙂
Its working fine...
Thanks & Regards,
Srividhya
in addition you can add ... the below
Sub Zoom
rem ** fit active sheet to window and apply same zoom to all sheets **
ActiveDocument.ActiveSheet.FitZoomToWindow
ActiveDocument.GetApplication.WaitforIdle
ActiveDocument.ActiveSheet.ApplyZoomToAllSheets
End Sub
and do macro OnOpen and it should go for all Sheets ..
if you facing a prablom jest make a botton on the first sheet thet make this macro
Hi Guy tzumer
Kindly thnx for ur reply.
Regards,
sri
Hi Kurup,
Please find the attachment its cums every time while am opening the application 1st time in every tab.
let me knw the solution.
Thanks in advance
Regards.
Sri
Or any other way for the same action
Hi Srividya,
try out wat Guy has suggested and trigger it in the open event of the application and check if you are facing the issue.