Selective Cell Protection

zarn

New Member
Joined
Jun 19, 2002
Messages
4
How can I protect the formula cells so that my customers won't delete them accidentally? Thanks.
 

Excel Facts

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.

Yogi Anand

MrExcel MVP
Joined
Mar 12, 2002
Messages
11,454
Hi Zarn:

Welcome to the Board!

If you mark the cells that have Formulas as Locked and Hidden, and protect the worksheet, the formulas will not be seen, and having locked the cells will not permit tampering with the formulas -- but the worksheet must be protected for these features to kick in.

Regards!

Yogi
 

Chris Davison

MrExcel MVP
Joined
Feb 15, 2002
Messages
1,790
if they're peppered all over the place ( like mine usually are) a handy way of selecting them all in one go is to highlight your range, then :

edit
goto
special

and click on constants then untick everything except formulas

click ok

this'll select all formulae for you and you can right click in any one of them in order to proceed with Yogi's suggestion above (format, protection, protect and hide)

_________________
Hope this helps,
Chris
:)
[Excel '97; Windows ME]
This message was edited by Chris Davison on 2002-09-22 04:34
 

Forum statistics

Threads
1,144,437
Messages
5,724,356
Members
422,546
Latest member
KevinOnTheDaily

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top