+ Reply to Thread
Results 1 to 6 of 6

Find/Replace on unlocked cells in protected sheet

  1. #1
    Registered User
    Join Date
    05-05-2011
    Location
    india
    MS-Off Ver
    Excel 2007
    Posts
    8

    Find/Replace on unlocked cells in protected sheet

    Our worksheet has locked & unlocked cells in the same worksheet.

    I wish to perform find/replace on unlocked cells in the sheet.

    if i try to do find & replace i'm getting an alert message as "command cannot be executed on protected worksheet".

    but i want to perform find/replace only on unlocked cells on protected sheet.

    So please help me to get resolve this issue.

  2. #2
    Forum Expert pike's Avatar
    Join Date
    12-11-2005
    Location
    Alstonville, Australia
    MS-Off Ver
    2016
    Posts
    5,330

    Re: Find/Replace on unlocked cells in protected sheet

    Hi deepu.gouwtham,
    You will have to unlock the sheet first then lock it after
    If the solution helped please donate to RSPCA

    Site worth visiting: Rabbitohs

  3. #3
    Registered User
    Join Date
    05-05-2011
    Location
    india
    MS-Off Ver
    Excel 2007
    Posts
    8

    Re: Find/Replace on unlocked cells in protected sheet

    Hi pike,
    Thanks for the reply..
    but we protect the layout design on user interface(i.e.MS excel) and we want to provide find/replace option on the unlocked cells in protected sheet
    So please suggest me how to proceed on the same...

  4. #4
    Forum Expert pike's Avatar
    Join Date
    12-11-2005
    Location
    Alstonville, Australia
    MS-Off Ver
    2016
    Posts
    5,330

    Re: Find/Replace on unlocked cells in protected sheet

    Hi deepu.gouwtham

    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    05-05-2011
    Location
    india
    MS-Off Ver
    Excel 2007
    Posts
    8

    Re: Find/Replace on unlocked cells in protected sheet

    Pike once thanks for your quick reply.
    I'm very new to ms excel and vba programming
    so could you please give me a brief source code on how to proceed with it.

  6. #6
    Forum Expert pike's Avatar
    Join Date
    12-11-2005
    Location
    Alstonville, Australia
    MS-Off Ver
    2016
    Posts
    5,330

    Re: Find/Replace on unlocked cells in protected sheet

    Hi deepu.gouwtham,
    To check if a cell is locked

    Please Login or Register  to view this content.

    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1