Protect sheet Excel 2007

  • Thread starter Thread starter teepee
  • Start date Start date
T

teepee

When I protect a sheet in Excel 2007 I can't then allow users to edit
objects. Am I doing something wrong? Works fine in 2003
 
With the sheet unprotected, right click the edge of the shape and select
"Size and Properties". On the Properties tab uncheck "Locked".
 
With the sheet unprotected, right click the edge of the shape and select
"Size and Properties". On the Properties tab uncheck "Locked".

I can't get that option up. The object in question is a graph by the way.
 
With the sheet unprotected, right click the edge of the shape and select
"Size and Properties". On the Properties tab uncheck "Locked".

OK found it and did that. Made no difference.
 
Teepee

How about Review Tab>Changes Group>Allow Users to Edit Ranges. In the
resulting dialog, click on Protect Sheet... and check Edit Objects

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
www.nickhodge.co.uk

FREE UK OFFICE USER GROUP MEETING, MS READING, 27th APRIL 2007
www.officeusergroup.co.uk
 
How about Review Tab>Changes Group>Allow Users to Edit Ranges. In the
resulting dialog, click on Protect Sheet... and check Edit Objects

Nope same problem.
 
teepee

You seem to have broken up the thread, you issue appears to be with VBA. See
my answer in other thread, In the UI this feature still works. At least if
my understanding and testing are in line with yours

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
web: www.nickhodge.co.uk
blog: www.nickhodge.co.uk/blog/

FREE UK OFFICE USER GROUP MEETING, MS READING, 27th APRIL 2007
www.officeusergroup.co.uk
 
"Nick Hodge" wrote

You seem to have broken up the thread, you issue appears to be with VBA. See
my answer in other thread, In the UI this feature still works. At least if
my understanding and testing are in line with yours

Apologies - I'll stick to this thread. Yes it is the VBA function that
doesn't work. I hadn't realised it was still working on the UI so I didn't
mention that.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Chartobjects protected but it can still be deleted, edited and movedby the user (yes, the sheet is p 5
2003 checkboxes and sheet protection opened in 2007 2
Allow comments in protected sheet using VB 4
Allow Users to Unfreeze Panes in a Protected Workbook/Sheet 2
Protect a worksheet but allow cell editing 3
Excel 2007 "Protect Sheet" option not available 1
Using Activebook.Unprotect in macro giving errors (Password) 1
Print Preview allows margin change in protected sheet 1

Back
Top