Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
am nt sure chk dis option for all objects and try ?
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.
Thanks swuehl,
The maximun size is a property or I fixed it by moving the borders??
Thanks
You can set the width and height in caption tab or drag the borders using the mouse.