View Single Post
  #7   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

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.