Consulting

Results 1 to 4 of 4

Thread: Lock pictures so immovable (but do not want to lock objects)

  1. #1
    VBAX Newbie
    Joined
    Dec 2018
    Posts
    1
    Location

    Lock pictures so immovable (but do not want to lock objects)

    I am using Excel 2016 32-bit as part of Office 365 ProPlus.

    I would like to lock the pictures in my worksheet so they cannot be moved or resized but I do not want to lock objects. I have drop down ComboBoxes in the sheet too which people need to be able to type in and select options so couldn't use Protect Sheet and lock 'Edit objects'.

    VBA code was suggested as a solution. Is it possible and can anyone help?

    Thank you.

  2. #2
    VBAX Regular
    Joined
    Jul 2018
    Posts
    17
    Location
    Why don't you merge cells to create the size and location you want for the picture, then put the image into the resulting cell ?

    https://trumpexcel.com/insert-picture-into-excel-cell/

  3. #3
    VBAX Master Aflatoon's Avatar
    Joined
    Sep 2009
    Location
    UK
    Posts
    1,720
    Location
    You can't just lock pictures. Can you use Data Validation dropdowns instead of dropdown controls?
    Be as you wish to seem

  4. #4
    VBAX Mentor 大灰狼1976's Avatar
    Joined
    Dec 2018
    Location
    SuZhou China
    Posts
    479
    Location
    Hi Sparkle!
    Even lock objects will not affect ComboBox(or my understanding is wrong?).
    for a simple example, Please refer to the attached.
    Attached Files Attached Files

Posting Permissions

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