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?
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?
I am all set with this.
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!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks