Macro for activating sheet

[Anonymous]

Hi,

I have a list box , if i select a value in list box sheet has to be activated.

Example: i have list box and 3 sheets

List Box

Income

Loss

Margin

If i select loss , loss sheet has to be activated and curren sheet has to be de activated.

Thanks in advance

[#2]

Change the list box to "Always one selected value" on the general tab. You have to select a value first.

Change the sheet (eg. Income) from always show to conditional, with the condition like:

GetFieldSelections(FieldName)='Income'

Repeat with the other sheets.

[Anonymous]

HI Dave,

Thanks a lot it worked...