How to do restrict my sheet?

[gkcchowdary]

Hi I have two sheets sheet1and sheet2.and created charts in both sheet.if I select anything in sheet1 it automatically select sheet2 also.

So my requirement is if I select any filed in sheet1 no need to reflect sheet2.my selection happen only sheet1 not sheet2.how implement.

Thanks

Chaitanya

[prma7799]

Use trigger in sheet properties

Please check this

OnActivateSheet trigger

[devarasu07]

Hi,

Try to configure sheet property trigger action like below screen

[Siva_Sankar]

Hi Chaitanya,

Right click on sheet 1--> Sheet properties window opens.

click OnLeaveSheet button-->In Action type, click Selections

In Selections-->click 'Clear All' Action and click OK.

Whatever selction you make will be cleared off when you leave sheet 1.

Find the attached screenshot for reference.

Siva