Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Find Function on Excel 2007

Posted on 2011-09-19
3
292 Views
Last Modified: 2012-05-12
Hi All,

I have an excel spreadsheet which needs to be protected.

Problem, Once I protect the workbook, I cannot find on it anymore.

Is it possible to be able to find (Ctrl+f) on the worksheet once it is protected.
0
Comment
Question by:thorpey83
  • 2
3 Comments
 
LVL 19

Expert Comment

by:akoster
ID: 36559898
In order to be able to use the Find option, you should allow the user of the protected worksheet to select protected cells and to select unprotected cells (the first two option checkboxes).

You can do this by unprotecting the spreadsheet and then protecting it again.
0
 
LVL 6

Expert Comment

by:TinTombStone
ID: 36559921
Find works fine on a protected Excel 2010 sheet.  Can't see why it would be different on 2007

Does the Find Dialog open when you press Ctrl+F?  
Does it open from the the Home tab?


0
 
LVL 19

Accepted Solution

by:
akoster earned 500 total points
ID: 36559981
TinTombStone,

the find function in itself does work on protected excel sheets, both in 2010 and in 2007 versions.
When the protection option disables selecting cells however, it will be rendered useless.
0

Featured Post

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Possible fixes for Windows 7 and Windows Server 2008 updating problem. Solutions mentioned are from Microsoft themselves. I started a case with them from our Microsoft Silver Partner option to open a case and get direct support from Microsoft. If s…
Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

838 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question