 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / March 2007Protect sheet Excel 2007
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".  SignatureJim > 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". 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 SignatureHTH Nick Hodge Microsoft MVP - Excel Southampton, England nick_hodgeTAKETHISOUT@zen.co.ukANDTHIS www.nickhodge.co.uk FREE UK OFFICE USER GROUP MEETING, MS READING, 27th APRIL 2007 www.officeusergroup.co.uk > 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 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 SignatureHTH Nick Hodge Microsoft MVP - Excel Southampton, England nick_hodgeTAKETHISOUT@zen.co.ukANDTHIS 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 > 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. 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. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.