Databases Reference
In-Depth Information
The difference between these two options is that using
Paste Sheet Object
creates a
copy of the object, which is independent of the source object. The
Paste Sheet Object
as Link
option, on the other hand, creates an additional instance (or linked object) of
the source object. Any changes made to the layout properties of a linked object will
be applied to all other linked objects, with the exception of size and position.
The size and position of linked objects can be updated
manually by right-clicking on the object and selecting
Linked Objects
|
Adjust Position of Linked Objects
.
When the same object is used in many different places, such as listboxes that appear
on every sheet, using linked objects can make maintenance a lot more convenient.
Drag and drop to copy or create linked objects
Objects can also be copied or linked by dragging
and dropping.
To copy an object, hold down the
Ctrl
key while clicking on
the object's caption and drag the object. A small green plus
sign on your cursor will indicate that you are copying an
object. Release the mouse cursor on an empty space on the
worksheet to create a copy.
Creating a linked object works very similarly to copying an
object. Hold down
Ctrl
+
Shift
while clicking on the object's
caption. A small chain icon on your cursor indicates that you
are linking an object. Drag and release the mouse cursor on
an empty space on the worksheet to create the linked object.
Of course, we can also create copies or linked objects on
sheets other than the source sheet. To do this, instead of
dragging the object to an empty space on the worksheet, drag
it to the tab corresponding to the target sheet. The object will
appear in exactly the same position as the source object, but
on the other sheet.
Let's see how linked objects work by following these steps:
1.
On the
Dashboard
tab, create a copy of the
Carrier Name
listbox by holding
down the
Ctrl
key, clicking on the header, and dragging the listbox to an
empty space on the worksheet.
2.
Right-click on the new copy and select
Properties…
.
3.
On the
General
tab, set the
Title
of the listbox to
Copy
.
4.
On the
Font
tab, set the
Font Style
to
Bold
and the
Font Size
to
16
.
