Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Could anyone help me to activate sheed based on a value selection in a list box. I couldn't pass the Sheet ID properly while activating the trigger in Document properties. Thanks in advance.
- Sasi
In your variable vSheet use maxString(SID)
Could you post your sample app? Or could you descibe your problem is bit closer?
Hi Swuehl, Please find the attached application. I'm trying to activate Sheets A,B based on the corresponding selection in the list. I couldn't get this working.Please let me know if you need any details from me. Thanks
In your variable vSheet use maxString(SID)
Look a the Sheet Properties > General tab > Show Sheet > Conditional
Just change your sheet ID expression in your activate sheet action (document properties) to
=SID
Regards,
Stefan
Thanks all for your help. It works now. Fed's input works for me . - Sasi
Hi
Its fine , but if I select Sheet A it is getting visible but the focus remains on list box ,what to do for the the sheet A activated and focus got to Sheet A