CONVERTING Excel 2003 Commands to 2007

R

Ra

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.
 
R

Ra

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.
 
B

Bernard Liengme

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
 
R

Ra

Bernard

The answer is Yes.

Thank you.



Bernard Liengme said:
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
 
B

Bernard Liengme

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top