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?
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?
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks