Redim objects in a sheet

[Anonymous]

Hi,

I have some objets in a sheet.: tables, graph, etc...

When I make selections in listboxes table change of size, sometimes the table is large and get over the graph that is below the table , then when table get boigger graph is under the table (graph hidden for the table)...., I don't know how resize objects, if I can put dependencies between objets to control size not to have problems.

Sorry my english is not good..., I have tried to explain my problem...

Can anybody help me?, best practices?

Thanks

[miguelbraga]

Hi Juan,

See these options in the properties of the listboxes:

Uncheck "Allow Move/Size" or "Size to Data" maybe

Hope it helps

Regards,

MB

[Chanty4u]

am nt sure chk dis option  for all objects and try ?

[swuehl]

You should be able to set a maximum size of your objects just by grabbing the border (you should see the border also when activating the design grid in menu View).

Then the charts should not get bigger than that, but show scroll bars when needed.

[Anonymous]

Thanks swuehl,

The maximun size is a property  or I fixed it by moving the borders??

Thanks

[swuehl]

You can set the width and height in caption tab or drag the borders using the mouse.