+ Reply to Thread
Results 1 to 3 of 3

Find and go to instant in protected worksheet

  1. #1
    Forum Contributor
    Join Date
    04-05-2013
    Location
    CT
    MS-Off Ver
    Excel 2010
    Posts
    360

    Find and go to instant in protected worksheet

    I'm looking to use the Find function in order to search through a protected worksheet. Currently I can use it to search, however, I am unable to click on the results to bring me to each instant. Any ideas?

  2. #2
    Forum Contributor
    Join Date
    04-05-2013
    Location
    CT
    MS-Off Ver
    Excel 2010
    Posts
    360

    Re: Find and go to instant in protected worksheet

    I am all set with this.

  3. #3
    Forum Contributor
    Join Date
    08-02-2013
    Location
    Wageningen, The Netherlands
    MS-Off Ver
    365
    Posts
    495

    Re: Find and go to instant in protected worksheet

    That's the whole idea of protecting a worksheet. The person who set the protection, has checked "do not allow selecting protected cells" so you can't...
    However if you do have some unprotected cells, you can just refer to the protected cells (if A1 is unprotected and B1 is the cell you need, just put =B1 in A1)
    When I say semicolon, u say comma!

+ 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. [SOLVED] Find & Replace within Unlocked Cells in a Protected Worksheet
    By DaveyC4S in forum Excel General
    Replies: 4
    Last Post: 06-28-2023, 11:28 PM
  2. Copy and paste insert rows with protected cells in protected worksheet
    By excel_gecko in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-24-2012, 05:50 PM
  3. Instant Comment Box
    By Sanecrazy in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-07-2012, 10:38 AM
  4. Instant Notification
    By Lotus123 in forum Excel General
    Replies: 1
    Last Post: 10-31-2007, 03:12 PM
  5. [SOLVED] How do I unlock a protected worksheet:password protected
    By Terry Swift in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-01-2005, 09:05 PM

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