+ Reply to Thread
Results 1 to 4 of 4

locking shapes and pictures on excel sheet

  1. #1
    Forum Contributor
    Join Date
    03-14-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    491

    locking shapes and pictures on excel sheet

    How do you lock inserted images and shapes on an excel spreadsheet?

    I've done this by locking the sheet (with password) but it locks everything on the sheet.

    I want it so anyone else that opens the macro won't be able to move the images/shapes.

    I tried locking specific cells...but again...it locks the whole sheet.

    any help/ guidance would be appreciated.

  2. #2
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: locking shapes and pictures on excel sheet

    This won't work without the sheet being locked but you can allow editing in specific cells:

    Please Login or Register  to view this content.
    or maybe:

    Please Login or Register  to view this content.
    Last edited by xladept; 12-29-2013 at 07:27 PM.
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin

  3. #3
    Forum Contributor
    Join Date
    03-14-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    491

    Re: locking shapes and pictures on excel sheet

    Quote Originally Posted by xladept View Post
    This won't work without the sheet being locked but you can allow editing in specific cells:

    Please Login or Register  to view this content.
    or maybe:

    Please Login or Register  to view this content.
    Thank you for the code

  4. #4
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: locking shapes and pictures on excel sheet

    You're welcome!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 8
    Last Post: 01-11-2015, 06:01 PM
  2. Pull pictures from folder to excel sheet...HELP
    By iowitz in forum Excel General
    Replies: 5
    Last Post: 12-06-2013, 03:03 PM
  3. Pull pictures from folder to excel sheet...HELP
    By iowitz in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-06-2013, 02:11 PM
  4. Shapes/pictures that are on the slide onscreen, but don't print
    By raperm in forum PowerPoint Formatting & General
    Replies: 0
    Last Post: 08-01-2013, 01:37 PM
  5. Replies: 1
    Last Post: 07-21-2006, 11:05 AM

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