+ Reply to Thread
Results 1 to 2 of 2

Lock location of Object

  1. #1
    Registered User
    Join Date
    10-11-2012
    Location
    Florida
    MS-Off Ver
    Excel 2010
    Posts
    4

    Lock location of Object

    Is there a way to lock the location of an object so a user cannot move it, if the sheet is protected but still allow it to be clicked?

  2. #2
    Forum Expert
    Join Date
    01-23-2013
    Location
    USA
    MS-Off Ver
    Microsoft 365 aka Office 365
    Posts
    3,863

    Re: Lock location of Object

    Hi Justin,

    In Excel 2003: Tools > Protection > Protect Sheet > DO NOT CHECK 'Edit Objects'
    In Excel 2010: Home > Format > Protect Sheet > DO NOT CHECK 'Edit Objects'

    Lewis

+ 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. Lock Individual Object
    By RunRabbit13 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-17-2014, 02:13 PM
  2. Lock Size of WMP Object in Spreadsheet
    By R_S_6 in forum Excel General
    Replies: 3
    Last Post: 11-21-2013, 12:31 PM
  3. Replies: 0
    Last Post: 09-04-2013, 04:33 PM
  4. how to insert ole object textbox at particular location
    By pankajy18 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-09-2013, 01:02 PM
  5. Lock Size of WMP Object in Spreadsheet
    By R_S_6 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-11-2009, 05:04 AM
  6. method 'location' of object '_Chart' failed.
    By Hendel in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 10-29-2008, 01:03 PM
  7. Lock shape location to axis values?
    By William DeLeo in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 12-29-2005, 09:09 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