| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Protect formula without protecting the worksheet
I have several areas in my worksheet that I need to protect th formula's, my spreadsheet also has auto filter therefore I can' protect the worksheet or the filter won't work. The end user of this worksheet will also need to have the ablitity t delete rows. The area that I need to protect are as follows: T17:T83 X17:X83 AE17:AE83 AI17:AI83 AK17:AK83 AW17:AW83 AQ1:AU13 OR if it is easier any cell that contains a formula. Any and all help is appreciated -- lostinformula ----------------------------------------------------------------------- lostinformulas's Profile: http://www.excelforum.com/member.php...fo&userid=3522 View this thread: http://www.excelforum.com/showthread.php?threadid=55163 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can protect worksheet then workbook but not Protect and Share in code | Excel Programming | |||
| Protecting worksheet | Excel Worksheet Functions | |||
| Protect selected cells without protecting worksheet | Excel Discussion (Misc queries) | |||
| Un-Protecting a Worksheet | Excel Discussion (Misc queries) | |||
| protecting the worksheet | Excel Worksheet Functions | |||
![lostinformulas[_5_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
