How to hide formulas

smittycft99 · May 20th, 2002, 12:48 PM

When I go to format/cells/protection/ check hidden and locked cells
(I want to hide my formulas), then I go to protect sheet and choose the calculating cells. When I go to enter a reference in A1, then B1,C1,D1,E1 (populated with Vlookup function, also these are the cells with the formulas) give me an error that says sheet is protected...What am I doing wrong

Nimrod · May 20th, 2002, 12:51 PM

Protect the sheet AFTER you enter the formulas

... in other words protecting the sheet is the last step ...entering formulas is the first

[ This Message was edited by: Nimrod on 2002-05-20 11:51 ]

[ This Message was edited by: Nimrod on 2002-05-20 11:53 ]

smittycft99 · May 20th, 2002, 01:01 PM

Nimrod,

I did it in that order, but I am still getting problems.

Mudface · May 20th, 2002, 01:04 PM

Make sure all the cells where you want to enter data are unprotected. The way I often do it is to select the entire sheet, unlock the cells, enter formulas, formatting etc, lock those cells that I don't want people changing and then protect the sheet.

Nimrod · May 20th, 2002, 01:07 PM

Have you unchecked the cells that you want to enter data into once the sheet is protected ?

Have you checked the "answer wizard" i.e. type in "locked cells" and it will give you step by step instructions

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 20th, 2002, 12:48 PM	#1
smittycft99 Board Regular Join Date: Apr 2002 Posts: 130	When I go to format/cells/protection/ check hidden and locked cells (I want to hide my formulas), then I go to protect sheet and choose the calculating cells. When I go to enter a reference in A1, then B1,C1,D1,E1 (populated with Vlookup function, also these are the cells with the formulas) give me an error that says sheet is protected...What am I doing wrong

May 20th, 2002, 12:51 PM	#2
Nimrod MrExcel MVP Join Date: Apr 2002 Location: Vancouver BC , Canada Posts: 6,259	Protect the sheet AFTER you enter the formulas ... in other words protecting the sheet is the last step ...entering formulas is the first [ This Message was edited by: Nimrod on 2002-05-20 11:51 ] [ This Message was edited by: Nimrod on 2002-05-20 11:53 ]

May 20th, 2002, 01:01 PM	#3
smittycft99 Board Regular Join Date: Apr 2002 Posts: 130	Nimrod, I did it in that order, but I am still getting problems.

May 20th, 2002, 01:04 PM	#4
Mudface MrExcel MVP Join Date: Feb 2002 Location: Sunny, spring-like Hull Posts: 3,339	Make sure all the cells where you want to enter data are unprotected. The way I often do it is to select the entire sheet, unlock the cells, enter formulas, formatting etc, lock those cells that I don't want people changing and then protect the sheet.

May 20th, 2002, 01:07 PM	#5
Nimrod MrExcel MVP Join Date: Apr 2002 Location: Vancouver BC , Canada Posts: 6,259	Have you unchecked the cells that you want to enter data into once the sheet is protected ? Have you checked the "answer wizard" i.e. type in "locked cells" and it will give you step by step instructions