Solved

Protecting an object

Posted on 2016-10-14
3
45 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 26

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 26

Accepted Solution

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

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Introduction This Article is a follow-up to my Mappit! Addin Article (http://www.experts-exchange.com/A_2613.html), it was inspired by an email posting I made to EUSPRIG (http://www.eusprig.org/index.htm), I will briefly cover: 1) An overvie…
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

830 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