Results 1 to 2 of 2

Thread: [Resolved]Protect and Allow Edit Ranges

Threaded View

  1. #1

    Thread Starter
    Lively Member
    Join Date
    Mar 2006
    Posts
    74

    [Resolved]Protect and Allow Edit Ranges

    Hello! What is the correct code to protect a sheet but allow a rnage to be edited?

    My code below keeps bombing out?

    VB Code:
    1. ActiveSheet.Protection.AllowEditRanges.Add _
    2.     Title:="Range1", _
    3.     Range:=Range("A15:G1500")
    4.    
    5.    
    6.     ActiveSheet.Protect "password"


    the error is "application defined or object defined error"
    Last edited by gtg689a; May 4th, 2006 at 12:53 PM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width