Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
How do i remove a sheet in a qlik document using a macro?
Please help me.
Best regards and thanks in advance.
Hi Onixdiana,
What do you mean with remove? delete? hide?
Please, let us know what exactly you want.
Best regards.
Hi Miguel,
Both of the deleting or hiding represents a solution for want i need.
A have a document which has a macro for saving the document somewhere else, to reduce some data and then send that information via email.In this document, in the last sheet i put a button to activate the macro, but the person who will get the email is just a user and for preventing the push of that button, i want to hide/remove the entire sheet.
Thank you very much and i hope you will help me.
Best Regards.
Hi OnixDiana,
here you are my solution, see the follow aspect:
I hope this help you.
Best regards
I have Qlikview 8.1 installed on my pc and i can't open your file.
Can you try to send me again pls.
Hi OnixDiana,
I don't have any problem sending it for you again, but it's very strange you can't open it, I've saved it for Qlikvie 6 to 8 version.
I hope you can download and open it correctly.
I've decided to describe the steps for get it:
Best regards.
I try it but i need to hide it before the macro sends the mail to the users.
Anyway thank you very much.
Best Regards.
Your application works correctly in my system. It hides the tab" To Hide " when the button is clicked and it again reappears when it is clicked the second time.
Hi OnixDiana,
There isn't problem with that, you could call the procedure for sending mail in the same procedure like as following:
sub hide
set v = activedocument.Variables("v_hide")
if v.getContent.string = "1" then
v.SetContent "0",true
else
v.SetContent "1",true
end if
call send_mail
end sub
sub send_mail
msgbox "Sending mail"
end sub
I hope this help you.
Best regards.