1 Select all the cells in the worksheet (or at least the area you are using)
2 On the Home tab, click the launcher arrow on the Font group label and open
the Format Cells dialog;
open the Protection tab and uncheck the "Locked" box to unprotect all cells
3 On the Home tab, locate the Find & Select group at far right and click it;
click on Go to. In the Go To dialog check the "Formula" box. Now again use
the Home tab, click the launcher arrow on the Font group label and open the
Format Cells dialog; open the Protection tab and uncheck the "Locked" box to
protect all cells having formulas
4 In the Review tab in the Changes group, click Protect Worksheet. In the
resulting dialog there is a list under "Allow all users of the worksheet
to:" -- make sure only "Select Unlocked Cells" is checked
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email
"Ra" wrote in message
...
Bernard
The answer is Yes.
Thank you.
"Bernard Liengme" wrote:
Hopefully you meant "still be able to input data into all the cells in
the
worksheet THAT DO NOT CONTAIN FORMULAS". Otherwise how can you protect
the
worksheet?
If YES I will give you the steps
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email
"Ra" wrote in message
...
Bernard
Thank you for your reply. The series of commands, although worked in
2003,
they do not give me the same result in 2007. Any ideas?
What I want to do is to hide the conditional formating and formulas,
yet
still be able to input data into all the cells in the worksheet.
Thank you.
"Bernard Liengme" wrote:
The interactive guide at
http://office.microsoft.com/en-us/ex...491511033.aspx
will reveal all
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email
"Ra" wrote in message
...
Please can you let me know how I may convert these commands into
Excel
2007
Unprotect the sheet/ Unlock all cells/ Edit Goto Special
Formula
Format Cells... Protection Locked..Protect the sheet
Thank you.