+ Reply to Thread
Results 1 to 3 of 3

VBA for Find & Replace function on protected sheet

  1. #1
    Forum Contributor
    Join Date
    07-13-2017
    Location
    Hong Kong
    MS-Off Ver
    MS Office 365
    Posts
    481

    VBA for Find & Replace function on protected sheet

    Hi all,

    I need to somehow enable the find & replace function within my workbook without giving clients the password for my protected sheet. Within each sheet, there will be a few hundred unlocked cells, so I want them to be able to do a find & replace in there but not within the locked cells. So if they select locked AND unlocked cells, it should only do the find & replace within the unlocked range.

    I currently use below module to do just that. Though, the find & replace window is very generic and a lot worse than the built in one. e.g. it does not tell you how many replacements were made, nor can you undo things (not sure that's feasible with vba). Is there a way to more closely replicate the actual find & replace function?

    Please Login or Register  to view this content.

  2. #2
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,108

    Re: VBA for Find & Replace function on protected sheet

    Hello esbencito,

    Maybe it could just be a Code stacking issue. Unfortunately you did not provide a sample Workbook for testing, but please try;

    Please Login or Register  to view this content.
    Regards.
    Please consider:

    Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .

  3. #3
    Forum Contributor
    Join Date
    07-13-2017
    Location
    Hong Kong
    MS-Off Ver
    MS Office 365
    Posts
    481

    Re: VBA for Find & Replace function on protected sheet

    Hi,

    Sorry for the late reply. Just tried your code, but it happens to be the same as my version, doesn't seem to make any difference. I have attached a sample workbook for further clarification. In this workbook, the sheet is protected but the grey, blue and green cells are unlocked. This is where people do adjustments and want to use find replace. So basically I want to enable find replace for them but only for these unlocked cells. They shouldn't be able to change any other cells...
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Multiple Find/Replace on a specified sheet and outputtingin a separe sheet
    By scfn in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-24-2013, 07:27 AM
  2. Multiple find and replace from Glossary sheet to the active sheet
    By Chandru71 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-22-2011, 12:34 PM
  3. Find/Replace on unlocked cells in protected sheet
    By deepu.gouwtham in forum Excel General
    Replies: 5
    Last Post: 06-12-2011, 07:34 PM
  4. how to do a find & select in a protected work sheet
    By tvonbehren in forum Excel General
    Replies: 7
    Last Post: 11-08-2009, 05:19 PM
  5. Find/Replace on a protected sheet
    By LAF in forum Excel General
    Replies: 1
    Last Post: 07-10-2009, 09:32 PM
  6. Find/Replace on a protected sheet
    By LAF in forum Excel General
    Replies: 1
    Last Post: 06-23-2009, 07:39 AM
  7. [SOLVED] Replace on a password protected sheet
    By Matt in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 11-04-2005, 11:40 AM
  8. [SOLVED] Find & Replace within Unlocked Cells in a Protected Worksheet
    By DaveyC4S in forum Excel General
    Replies: 2
    Last Post: 10-09-2005, 07:05 AM

Tags for this Thread

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