+ Reply to Thread
Results 1 to 2 of 2

Locking a Picture to a Cell

  1. #1
    Registered User
    Join Date
    01-27-2005
    Posts
    1

    Unhappy Locking a Picture to a Cell

    Hi,
    I have a sheet whith my dvd movies. Each row has :

    column a column b column c

    small picture name actors

    When I trie to sort , the pictures remain in original position and don't follow is original row.
    How can I "lock" the picture to the cell ???
    Can somebody help me ?

  2. #2
    Forum Contributor
    Join Date
    11-16-2004
    Posts
    282
    You'll need to do this for each picture in your spreadsheet:

    Right-click on the picture, then select Format Picture...

    Select the 'Properties' tab, then select 'Move but don't size with cells' option.

    OR

    copy this macro to your file and run it (make sure the sheet w/the list is selected):

    Please Login or Register  to view this content.

    Hope this helps,
    theDude

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1