topic Re: Execute 2 macros in one button in QlikView

Execute 2 macros in one button

karin_nevo — Wed, 23 Nov 2016 05:58:11 GMT

Hi,

I am trying to create a button to set specific Zoom and apply it to all sheets.

I am using IE Plugin.

I was unable to create both actions in one macro, so I seperated it into 2 macros, but it only works if I am using 2 buttons (instead of one button with 2 actions).

the macros I am using are:

1. For Zoom:

sub ZOOM
set mysheet=ActiveDocument.ActiveSheet
set sp=mysheet.GetProperties
sp.ZoomFactor = 1.25
mysheet.SetProperties sp
End sub

2. To apply to all sheets:

sub ApplyZoom
ActiveDocument.ActiveSheet.ApplyZoomToAllSheets
End sub

Any idea how I can solve it?

thanks!

Re: Execute 2 macros in one button

tamilarasu — Wed, 23 Nov 2016 06:09:36 GMT

Hi Karin,

You can use below code.

Sub Zoom

For i = 0 to ActiveDocument.NoOfSheets - 1

set mysheet=ActiveDocument.Sheets(ActiveDocument.Sheets(i).GetProperties.Name)

set sp=mysheet.GetProperties

sp.ZoomFactor = 1.25

mysheet.SetProperties sp

End sub

Re: Execute 2 macros in one button

karin_nevo — Wed, 23 Nov 2016 09:58:48 GMT

Thank you Tamil, it works perfectly

Re: Execute 2 macros in one button

rubenmarin — Wed, 23 Nov 2016 10:18:40 GMT

Hi karin, if Tamil answer was what you are looking for, please check Tamil's answer as the correct answer to close the thread.

This helps other users with similar issue to find the answer and others (like me) to not use time reading an already solved question.