topic Re: Unable to Fire Macros in QlikView

Unable to Fire Macros

olaoyesunday1 — Mon, 18 Mar 2024 15:52:29 GMT

I wrote the below Macro code using VBScript I know the code is correct. Anytime I press the button attached to macro on my system instead of the script to fire it was reopening the macro editor. please, what can I do apart from changing module security to system access in which I did but it is not running.

Sub HideTabRow
Set DocProp = ActiveDocument.GetProperties
DocProp.ShowTabRow=False
ActiveDocument.SetProperties DocuProp
End Sub

Sub ShowTabRow
Set DocProp = ActiveDocument.GetProperties
DocProp.ShowTabRow=True
ActiveDocument.SetProperties DocuProp
End Sub

Re: Unable to Fire Macros

rwunderlich — Tue, 19 Mar 2024 05:09:55 GMT

When the macro editor opens like that, it indicates a runtime error is occuring in the vbscript. With the macro editor open, click the "Test" button to test your sub and get a better error message.

-Rob
http://www.easyqlik.com
http://masterssummit.com
http://qlikviewcookbook.com

Re: Unable to Fire Macros

olaoyesunday1 — Tue, 19 Mar 2024 09:35:00 GMT

@rwunderlich Thanks very much. But I tried and couldn't find any error. The screenshots of the code are below:

Re: Unable to Fire Macros

marcus_sommer — Tue, 19 Mar 2024 11:01:43 GMT

You have a typo in both routines - see the red:

DocProp.ShowTabRow=False
ActiveDocument.SetProperties DocuProp

Re: Unable to Fire Macros

olaoyesunday1 — Tue, 19 Mar 2024 11:25:06 GMT

@marcus_sommer

Thanks very much . It works now