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.