 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / June 2008Is there a way to dissallow users from deleting formulas (and data) in a column
Does anyone know whether there is a preferred way to dissallow users from deleting formulas (and data) in a column? I have a shared document that contains formulas in certain columns. On occasion, users will likely accidentally delete the contents of those cells (thus eliminating those necessary formalas). Is there any way to prevent them from doing so? Thanks. You can lock the cells and then protect the worksheet. But there are lots of things that aren't available when the worksheet is protected. > Does anyone know whether there is a preferred way to dissallow users > from deleting formulas (and data) in a column? [quoted text clipped - 5 lines] > > Thanks.  SignatureDave Peterson > You can lock the cells and then protect the worksheet. > [quoted text clipped - 14 lines] > > Dave Peterson actually, most of the things that you'd want to still allow can be "turned on" when you do the protection... lock the cells and then goto tools->protect sheet and see all the choices. You may want to check everything on the list. Excel is smart enough that it won't allow you to delete a column with a locked cell or anything like that... "Most" doesn't really apply -- well, to me anyway. If there's one important thing that I can't do, then it's enough to not want to protect the sheet. > > You can lock the cells and then protect the worksheet. > > [quoted text clipped - 20 lines] > everything on the list. Excel is smart enough that it won't allow you > to delete a column with a locked cell or anything like that... SignatureDave Peterson For you and me that's probably accurate. For internal users of a workbook I find that only the rarest of corner cases is not covered by the defaults. You ever use data|subtotals or data|group? Lots of people do and want to expand contract rows whenever they want. > For you and me that's probably accurate. For internal users of a > workbook I find that only the rarest of corner cases is not covered by > the defaults. SignatureDave Peterson A couple of techniques I use: 1: Shade boxes light blue that require user input. Yellow boxes for output (formulas) 2: Protect the cells that have formulas. Unprotect the cells that require user input 3: Hide cells (rows or columns) with formulas) 4: Turn off display of formulas when needed. 5: for cases where you want open input- for example entering a temperature either in C or F to get the opposite, I have used slider controls so both cells, (°F and °C are changed simultaneously, so the user can slide away without ruining either formula). Hope this helps. Paul > Does anyone know whether there is a preferred way to dissallow users > from deleting formulas (and data) in a column? [quoted text clipped - 5 lines] > > Thanks. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.