Detaching Sheet

[prabhu0505]

Is it possible to detach a sheet from the document?

Regards,

Prabhu

[prabhu0505]

any idea?

[amars]

Hi Prabhu,

I don't know about detaching the sheet but you can hide the sheet by going in Sheet Properties->General->Show Sheet -> Conditional & put a formula over here for conditional hiding of the sheet(i.e u can make use of a variable also to show it or hide)

With Regards

Amar

[prabhu0505]

Thanks for your reply, Amar.

But I'm looking for detaching or isolating a sheet.

This I thought of doing by loading(aliasing) new fields from the existing fields, but I dont whether it will take additional memory, so I stand there.

Any views?

[#5]

HI. You could do a macro that Deactives every Sheet object in the Sheet you want to isolate.

[kuba_michalik]

Do you mean detaching as in detaching an object (it will "freeze" at its current state, i.e. further selections will not modify its state until it is attached again) or as in making a sheet fully independent (sheet is oblivious to selections made on other sheets, and likewise other sheets do not react to selections made on the isolated sheet)?

[#7]

I need some help with making the sheet as you said "fully independent". I got one tab/sheet that I dont want to reflect the selections made on other sheets and vise versa.

Any idea on how to solve this?

[#8]

You could use triggers and macro... See the API Guide..

[matt_crowther]

a) There will be a vb Macro based solution to this; somehthing involving 'GetSheetObjects', a loop and 'Detach' no doubt...but sadly my vb skills don't stretch that far - someone like Rob 'The Wonder' Wuderlich could do it in their sleep: he's an Obi Wan to my Wedge Antilles (or Jar Jar Binks!?)

b) As a half-way solution: set Triggers on activation and de-activation of the sheet you wish to detach to 'Clear all Selections' that way as soon as you enter or leave the 'detached' sheet all previous selections will be removed creating the illusion of detachment.

Hope that helps,

Matt - Visual Analytics Ltd