Power Query Course in Spanish
Thanks Thanks:  0
Likes Likes:  0
Page 2 of 2 FirstFirst 12
Results 11 to 12 of 12

Thread: Worksheet Range Protection

  1. #11
    New Member
    Join Date
    Mar 2002
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Unfortunately, it's a very large company so they are restricted to the IT "gods" decision on when and how upgrades happen...

    You know how that goes!


  2. #12
    New Member
    Join Date
    Dec 2008
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Worksheet Range Protection

    Hi,

    I am trying to protect the sheet while also trying to have few cells editable for the user to enter data.

    Rng = 1
    DestSht = "Summary"

    The below piece of code appears in a loop. The cells that are editable by the user depends on the cell index numbers.

    Range(Selection, ActiveCell.Offset(0, Col - 2 - cc - 1)).Select
    MyAddress = ActiveWindow.RangeSelection.Address(False, False)
    RngNm = "Range" & Rng
    Sheets(DestSht).Protect("pass-1")
    set c = Application.Sheets(DestSht).Protection.AllowEditRanges.Add(RngNm, Range(MyAddress), "pass-1")

    But the above line returns a "Application-defined or Object-defined error"

    Can anyojne pls help?

    Thanks
    Anusha

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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