Solved

Protecting an object

Posted on 2016-10-14
3
39 Views
Last Modified: 2016-10-17
Can I protect a grouped object on an excel spreadsheet so it cannot be edited but can be moved?
0
Comment
Question by:nathra
  • 2
3 Comments
 
LVL 25

Expert Comment

by:ProfessorJimJam
ID: 41843407
i think you can protect grouped object with worksheet protections but that will be also locking the movement.
0
 

Author Comment

by:nathra
ID: 41845143
Yeah, I figured that one out. Was just hoping there was a way to be able move the object with it locked.
0
 
LVL 25

Accepted Solution

by:
ProfessorJimJam earned 500 total points
ID: 41845398
AFAIK it is not possible .
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Compile Error 7 41
Excel case statements 3 24
Automating Excel Weekly Report 13 61
Excel range I cannot find 8 20
Drop Down List with Unique/Distinct Values (enhancing the Combo-Box with a few steps and a little code) David miller (dlmille) Intro Have you ever created a data validation list from a database field or spreadsheet column (e.g., Zip Codes or Co…
This tutorial explains how to create a series of drop-down lists that are dependent upon prior selections to guide (“force”) the user to make the correct selection and reduce data errors within Microsoft Excel. Excel 2010 was used for this tutorial;…
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

896 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now