Activating a sheet based on list value selection.

[ksasidhars]

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

[swuehl]

Could you post your sample app? Or could you descibe your problem is bit closer?

[ksasidhars]

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

[#4 · Accepted solution]

In your variable vSheet use maxString(SID)

[Larry_Aaron]

Look a the Sheet Properties > General tab > Show Sheet > Conditional

[swuehl]

Just change your sheet ID expression in your activate sheet action (document properties) to

=SID

Regards,

Stefan

[ksasidhars]

Thanks all for your help. It works now. Fed's input works for me . - Sasi

[romtech1]

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