Page 2 of 2 FirstFirst 12
Results 11 to 15 of 15

Thread: How to un-protect multiple cells in Excel worksheet with VBA

  1. #11
    MrExcel MVP
    Moderator
    Fluff's Avatar
    Join Date
    Jun 2014
    Location
    Chippenham
    Posts
    29,229
    Post Thanks / Like
    Mentioned
    483 Post(s)
    Tagged
    49 Thread(s)

    Default Re: How to un-protect multiple cells in Excel worksheet with VBA

    Do any of the cells you are unlocking intersect with a merged cell?
    - Posting Data try one of these tools
    - Posting guidelines, forum rules and terms of use
    - Read the FAQs

    Running Office 365 on Win 10

  2. #12
    Board Regular
    Join Date
    Jul 2012
    Location
    India
    Posts
    105
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: How to un-protect multiple cells in Excel worksheet with VBA

    Hi Fluff sir, sorry for late reply.
    Yes, most of these cells are merged.
    And I am not able to understand how to un-protect these cells.

  3. #13
    MrExcel MVP
    Moderator
    Fluff's Avatar
    Join Date
    Jun 2014
    Location
    Chippenham
    Posts
    29,229
    Post Thanks / Like
    Mentioned
    483 Post(s)
    Tagged
    49 Thread(s)

    Default Re: How to un-protect multiple cells in Excel worksheet with VBA

    You need to specify the full address of the merged cells, so instead of using K7, it would need to be something like K7:M7
    - Posting Data try one of these tools
    - Posting guidelines, forum rules and terms of use
    - Read the FAQs

    Running Office 365 on Win 10

  4. #14
    Board Regular
    Join Date
    Jul 2012
    Location
    India
    Posts
    105
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: How to un-protect multiple cells in Excel worksheet with VBA

    Hi Fluff sir, it is working great. Thanks a lot. Have a nice day ahead.

  5. #15
    MrExcel MVP
    Moderator
    Fluff's Avatar
    Join Date
    Jun 2014
    Location
    Chippenham
    Posts
    29,229
    Post Thanks / Like
    Mentioned
    483 Post(s)
    Tagged
    49 Thread(s)

    Default Re: How to un-protect multiple cells in Excel worksheet with VBA

    Glad to help & thanks for the feedback
    - Posting Data try one of these tools
    - Posting guidelines, forum rules and terms of use
    - Read the FAQs

    Running Office 365 on Win 10

Some videos you may like

User Tag List

Tags for this Thread

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
  •