Thread: Protect sheet Excel 2007
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming
Nick Hodge Nick Hodge is offline
external usenet poster
  
Posts: 1,173
Default 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



Reply With QuoteReply With Quote