Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
Protect 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 |
#2
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
Protect sheet Excel 2007
With the sheet unprotected, right click the edge of the shape and select
"Size and Properties". On the Properties tab uncheck "Locked". -- Jim "teepee" wrote in message ... 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 |
#3
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
Protect sheet Excel 2007
"Jim Rech" wrote in message ... 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. |
#4
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
Protect sheet Excel 2007
"Jim Rech" wrote in message ... 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. |
#5
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
Protect sheet Excel 2007
Teepee
How about Review TabChanges GroupAllow Users to Edit Ranges. In the resulting dialog, click on Protect Sheet... and check Edit Objects -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS www.nickhodge.co.uk FREE UK OFFICE USER GROUP MEETING, MS READING, 27th APRIL 2007 www.officeusergroup.co.uk "teepee" wrote in message ... 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 |
#6
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
Protect sheet Excel 2007
"Nick Hodge" wrote How about Review TabChanges GroupAllow Users to Edit Ranges. In the resulting dialog, click on Protect Sheet... and check Edit Objects Nope same problem. |
#7
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
Protect sheet Excel 2007
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 DTHIS 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 "teepee" wrote in message ... "Nick Hodge" wrote How about Review TabChanges GroupAllow Users to Edit Ranges. In the resulting dialog, click on Protect Sheet... and check Edit Objects Nope same problem. |
#8
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
Protect sheet Excel 2007
"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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Protect Excel 2007 but allow ungrouping | Excel Discussion (Misc queries) | |||
Protect an Excel 2007 workbook structure | Excel Discussion (Misc queries) | |||
Protect an Excel 2007 workbook | Excel Discussion (Misc queries) | |||
Protect sheet Excel 2007 | Excel Discussion (Misc queries) | |||
excel - macro code to open a protected sheet, enter passowrd, and then protect sheet | Excel Programming |