| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Two questions on worksheet protection and hiding formulae/ functions
Is there a line of code that will hide all cell formulae/ functions?
Is there a way to adjust the following code to apply to only cells populated with formulae/ functions? Private Sub Worksheet_Change(ByVal Target As Range) If Target.Formula < dtval Then Target.Formula = dtval End Sub Private Sub Worksheet_SelectionChange(ByVal Target As Range) dtval = Target.Formula End Sub 'From 'http://www.dotxls.com/excel-security/27/how-to-protect-an-excel-sheet-with-vba-macro-code |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hiding AddIn Methods from Worksheet Functions But Exposing to VBA | Excel Programming | |||
| some 'Protection' questions | Excel Worksheet Functions | |||
| Excel : Hiding/Locking Formulae | Excel Discussion (Misc queries) | |||
| 3 questions about automated c++ com add-in worksheet functions | Excel Worksheet Functions | |||
| Protection and Hiding Sheets | Excel Discussion (Misc queries) | |||
Threaded Mode
