Message when activating sheet

[guyvermeiren]

Hello,

I would like a message (or alert) showing up every time I activate a certain sheet in my application.

Is this possible.

Thanks,

Guy

[#2 · Accepted solution]

properties in your sheet -> Triggers -> On activet sheet Add action...External ->Run Macro

in your Macro just put something like MSGBOX('Your message!!')

[guyvermeiren]

Thanks Érico,

When I test this in the macro itself it works, but when I activate the sheet nothing happens. Do I have to add something else in my actions ?

Guy

[montubhardwaj]

Hi Guy,

I think you need to trigger the above Macro for the particular sheet.For example, If you want the message to apper on 2nd sheet, Trigger the macro for sheet 2.

REgards,

Sharma

[#5]

Nothing....look my example....

if still same doubt tell me!!!![View:http://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Discussions.Components.Files/11/6332.example.zip:550:0]!

[#6]

[View:http://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Discussions.Components.Files/11/2703.example.zip:550:0]

[montubhardwaj]

In 8.5, I will do something like this,

Write a macro as below:

SUB test

msgbox("Hello")

END SUB

Then go to

Settings-->Document Properties-->Sheets and choose the sheet where you want the message to appear and click on Properties --> Macro and Select your Macro.

Hope this was helpful.

Regards,

Sharma

[#8]

Maybe have something different on 8.5 version....

I never worked with that version.....anyone can help!!!

Sorry Sharma!!!

[guyvermeiren]

Érico,

I checked your example and did the same in my application, this works perfect.

Thanks to all repliers,

Guy