How to freeze sheet object

[Anonymous]

Hi,

I want to freeze the complete sheet object except one like listbox for selection purpose....My intention is, initially there will be one pop-up message like select one employee from list box that time other sheet objects are freeze .....After making a selection it should activate other freezed object and should show associated data.

Thanks

[srinivasa1]

Set condation for all sheet object.(layout condtional) except one object.

[Anonymous]

could you please illustrate more on it????

[Gysbert_Wassenaar]

You can use transparent text boxes and place them on top of your sheet objects. See attached example. I've not made the text boxes totally transparent so you can see they exist. Once you select one or more products in the listbox the text boxes will disappear. You can see why on the Layout tab of the properties window of the text boxes. The expression used for the conditional show option checks if there is a selection in the Products field. If there are no selections the text boxes are shown so the user cannot interact with the sheet objects under the text boxes.

[ashwanin]

What i am getting from your question is that, you have a model with Multiple sheet objects:

Now you do want when its idle (qvw) all Objects show Select Employee from the List box, and once the employee selected it from List box the data will reflect their. Is it?

How many sheet objects do you want to associate with it?

[Anonymous]

hey in ur case when text object is used..It always maintain its position infront of sheet object  but wen I am using any text object then sometime text object goes behind the sheet object....Is der any properties to do that?????

[Colin-Albert · Accepted solution]

On the text box layout tab set the layer to top.

[nagaiank]

You may set all objects except the listbox as "Read Only".