Solved

Protecting an object

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

ScreenConnect 6.0 Free Trial

Check out the updates in one game-changing release, ScreenConnect 6.0, based on partner feedback. New features include a redesigned UI that improves session organization and overall user experience. See the enhancements for yourself!

Question has a verified solution.

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

Suggested Solutions

Workbook link problems after copying tabs to a new workbook? David Miller (dlmille) Intro Have you either copied sheets to a new workbook, and after having saved and opened that workbook, you find that there are links back to the original sou…
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!
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 how to use a scrolling table in Microsoft Excel using the INDEX function.

773 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